Martijn Tonies wrote:
>>Have you heard of Explain Plan?
>
>
> Yes. But why does a " where proc.procedure_name is null " matter such
> a lot on an _inner join_ where there can be no such rows?
>
> (obviously, I left out that part of the WHERE in my final query).
Because it changes the assumptions made by the optimizer which should be
plainly visible with an explain plan.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Oct 09 2004 - 14:45:44 CDT
