Re: EXISTS() optimization
Glad to see this post, I have been wondering if there's a better way than select count(*) for these operations, and havent found a lot about it in the docs.
Not that I have a clue, but I believe the (select * from where ...) would run first, then EXISTS would determine if that set were empty, so you would have to run that entire select anyway.
Maybe someone who knows what they are talking about could jump in - whats the best way to determine existance or non existance of a row?
Subject
Views
Written By
Posted
19628
June 07, 2006 10:00AM
Re: EXISTS() optimization
6592
July 25, 2006 07:54AM
5616
July 25, 2006 01:13PM
5251
August 04, 2006 04:45AM
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.