Interview Question on Subqueries vs Regular joins
Date: Mon, 11 Feb 2008 08:44:52 -0800 (PST)
I was asked the following question at a technical interview: when would you use subqueries and when would you use regular joins (pros and cons of each approach in terms of design and performance)?
I have read several articles on the subject but could not find a good answer to this question.
Any help would be appreciated.
Thanks! Received on Mon Feb 11 2008 - 10:44:52 CST