Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
can someone tell me what could be the reason for difference in execution time in Oracle and SQL, as in Oracle it takes more time than Sql. both the places data, columns, keys , constraints are same still there is difference in execution.
please reply asap thank you.
Posted 28-Dec-12 20:46pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Execution time is dependent on data sizes and indexes defined on your tables. Both Oracle and SqlServer are highly optimized database engines and they should operate in the same league for your record numbers and hardware you are using.
If they are different then you must check the indexes you have defined.
philiplobo at 29-Dec-12 2:21am
the indexes given to both the tables are same.. hardware configuration is slightly different .

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Zoltán Zörgő 335
1 Peter Leow 155
2 BillWoodruff 120
3 CHill60 110
4 CPallini 80
0 Sergey Alexandrovich Kryukov 9,423
1 OriginalGriff 6,891
2 Peter Leow 4,692
3 Zoltán Zörgő 4,344
4 CHill60 2,932

Advertise | Privacy | Mobile
Web02 | 2.8.150129.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100