Home » RDBMS Server » Performance Tuning » Query Sql Server faster than Oracle (oracle 10g)
Query Sql Server faster than Oracle [message #577841] Thu, 21 February 2013 02:49 Go to next message
ltubio
Messages: 1
Registered: February 2013
Junior Member
Hi all, thanks for your time I comment my problem I have a query optimized as to it indexes and others runs immediately when the answer is few records in SQL Server such as Oracle, however when the result is large eg 20,000 records all data access times are very diferent. The query returns many fields (about 20) and some of them are of type Varchar 250 and some of 2000 I understand here may be the problem, but not is because for similar results (20,000 records) sql run in 2 seconds and Oracle but it responds little to have full data takes around 30 seconds. The problem is really in bringing information to all these fields since if the inquiry it also but only returning a numeric field is done in 2 seconds. Tests I've done them both through ODBC, in the Toad as in the own Oracle console on the server, so it is not problem Driver or flow of data through the network, I would like to think that this is some of the settings I think there is as much difference between Oracle and Sql. Do me can you help? PD. The databases are ORACLE 10 and SQL Server 2008
Re: Query Sql Server faster than Oracle [message #577844 is a reply to message #577841] Thu, 21 February 2013 03:09 Go to previous message
Michel Cadot
Messages: 58573
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For any performances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel
Previous Topic: Joins and in-line views
Next Topic: Please help me in rewriting the below query in optimized way
Goto Forum:
  


Current Time: Fri Jul 25 22:16:54 CDT 2014

Total time taken to generate the page: 0.08996 seconds