Home » RDBMS Server » Performance Tuning » Slowness of sql query (merged)
Slowness of sql query (merged) [message #381287] Fri, 16 January 2009 02:43 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,

We issue "SELECT * FROM <tname>;" from 2 schemas for a patricular table.

in schema 1, ttl record count is: 90000,
execution time: 350 msec.

in schema 2 , ttl record count is: 20000,
execution time: 9 msec.

both tables are having same structure and indexes.
And last_analyzed coumn shows current date.

Pls adv us the reason for slowness in schema 1.

rgds,
kesavan.



Re: Slowness of sql query [message #381288 is a reply to message #381287] Fri, 16 January 2009 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Both have the same number of blocks?
Both are in the same database?

Activate autotrace and check the result.

Regards
Michel
Re: Slowness of sql query [message #381290 is a reply to message #381287] Fri, 16 January 2009 02:45 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost/crosspost your questions.

Regards
Michel
Previous Topic: query taking lot of time
Next Topic: How i can increase the performance of my query
Goto Forum:
  


Current Time: Tue Dec 06 02:23:33 CST 2016

Total time taken to generate the page: 0.08790 seconds