OraFAQ Forum: Performance Tuning » Slowness of sql query (merged)

Home » RDBMS Server » Performance Tuning » Slowness of sql query (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Slowness of sql query (merged) [message #381287]

Fri, 16 January 2009 02:43

kesavansundaram
Messages: 183
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.

Report message to a moderator

Re: Slowness of sql query [message #381288 is a reply to message #381287]

Fri, 16 January 2009 02:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Slowness of sql query [message #381290 is a reply to message #381287]

Fri, 16 January 2009 02:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't multipost/crosspost your questions.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:24:25 CST 2024