Thanks for your response.
>>> <[EMAIL PROTECTED]> 7/19/2004 11:47:39 AM >>>
>It looks like your IN statement is forcing your inner SELECT to
execute
>once PER ROW of your main table. It is asking the engine to make sure
that
>_each and every_ id value in main meets the condition in the inner
>
It looks like your IN statement is forcing your inner SELECT to execute
once PER ROW of your main table. It is asking the engine to make sure that
_each and every_ id value in main meets the condition in the inner
select. So, for each and every value in the table main, it has to
re-computing t
