Re: Surprised at the optimizer...

> >>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.

Sounds like a bug then ;-)

Or a user asking for stupid things...

Haven't decided on the two yet.

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com