Re: Is a better way to have the same result of this query?

12/5/2002 1:06:03 PM, Jochem van Dieten <jochemd@oli.tudelft.nl> wrote:

>You start by using a dataset of realistic size. Sorry, but if the actual
>time is < 10.00 ms it is rather pointless to optimize further since
>chance is going to be the biggest factor. And the IN/EXISTS difference
>is dependent on dataset size.
>

Do you mean that using "EXIST" is not necessary out-perform using 'IN" even the "explain" say so? What is the right
size for those two key words?

Thanks for your very hepful information.

Vernon