Cartesian Products are not automatically wrong;
especially when you know that one of the tables
involved is to return a single row.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated July 27th
"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
news:n3vsh051rinjvad6qddr1elf5dn725p7m6_at_4ax.com...
> On 14 Aug 2004 11:35:33 -0700, mikerault_at_earthlink.net (Mike Ault)
> wrote:
>
> >I provide the script as a guideline,
>
> since when are scripts that are just plain wrong because of a
> cartesian product valid as a 'guideline'?
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sun Aug 15 2004 - 03:25:51 CDT
