Re: Performance for sub-select or joins

Actually, the execution plan will usually be the same for a sub-select or join, given they return the same results and use the same filtering conditions. In many cases, you can do essentially the exact same thing with either a join or sub-select, and the database will process it the same way. It's more of a logical difference rather than a physical difference.

Regards,

--
David C. Sisk
Database Architect
ReliaMetrics (formerly Emerald Business Unit)
Nortel Networks
(919) 992-0890
dsisk_at_nortelnetworks.com