Click here to Skip to main content
13,256,716 members (53,090 online)
Rate this:
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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.171114.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2017
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