Click here to Skip to main content
Rate this: bad
good
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 19:46pm

1 solution

Rate this: bad
good
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.
  Permalink  
Comments
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)



Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2014
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