Speaking from an Oracle perspective, it is generally better to use a join in
preference to an "IN" type subquery since the execution plan is normally
more efficient. However, some types of queries can only be solved with a
subquery clause such is the case with correlated subqueries.
This is a huge subject and the mod_perl list is not an appropriate forum for
this type of discussion.
Regards,
-----Original Message-----
From: ASHISH MUKHERJEE [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 9:20 AM
To: [EMAIL PROTECTED]
Subject: Table Joins
Hello everyone ! Can someone shed some light on something related to
databases. I'd like to know is it more expensive to perform a Table Join to
obtain a result or is it better to use a sub-query instead.
Thanks
Ashish
---
cout<<"Hello World !";
Get FREE Email/Voicemail with 15MB at Lycos Communications at
http://comm.lycos.com