Re: i've got the query optimization blues ... stumped
Posted by:
Toa Sty
Date: January 04, 2007 10:32AM
That's a lot to take in in one go. Have you tried starting with a really simple version of it and adding complexity slowly to see at what point things start going slowly? I'd probably take a look at just the subselect first.
So if you like, try posting the explain plans here in [ code ] tags for your query and just the subselect, and someone should be able to help.
(MySQL not using indexes when you think it should can be a result of analyze table not having been run for a while so you might want to try that before you start changing the query)
-----------------------------------------
email: 'toasty'*3 at gmail
Subject
Views
Written By
Posted
3021
December 15, 2006 02:48PM
Re: i've got the query optimization blues ... stumped
2119
January 04, 2007 10:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.