The extra table *is* being used: to create a cartesian product.
How could the optimizer (or better, the parser) know that it isn't your
intention?
--
reply address is altered to keep the spam down
remove the nospamplease part to reply...
Gert Rijs
gem at wirehub.nl
www.wirehub.nl/~gem
Dr. J. Sylvan Katz <jskatz_at_coombs.anu.edu.au> wrote in article
<35501E15.4CCF162E_at_coombs.anu.edu.au>...
> Can someone please explain why a cartesian product is produced if an
> extraneous table name is accidently put in the from clause? Can't the
> optimizer determine that the table is not being used?
>
> Regards
> Sylvan
>
>
Received on Tue May 05 1998 - 20:16:54 CDT
