Re: Very slow query, and, and, and...
Hi Peter,
thanks for your help. I take a look on joins (better i have to do) and optimize my queries a lot. Maybe this kind of queries is much to complex to use only "and(s)".
Hi Rick,
The optimizer_search_depth made it far more faster... but i dont know what this parameter sets up. I go now down to 0.002 seconds instead of nearly 3.000
WOW. But my query is still a weak one i think.
But thanks a lot you two.
Gerrit
Subject
Written By
Posted
Re: Very slow query, and, and, and...
January 06, 2015 05:11AM
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.