Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query taking too long, yet cost is low

OracleGuy777Sep 12 2008 — edited Sep 14 2008

hi guys,

I am running a query on two databases that were created the same way and have the same data.

On one the cost is nearly a million, and it runs in a matter of a few seconds
On the other, the cost is 40000, and it doesn't finish executing

I have looked at the explain plan, and there is no cartesian merge join on the second query, yet it is taking so long. What can I do to investigate this?

thanks

This post has been answered by Peter Fong-Oracle on Sep 13 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2008

Added on Sep 12 2008

#general-database-discussions

18 comments

2,175 views