Which type is more efficient Nested Subqueries or Joins

ashikrim · New User Joined: 18 Aug 2006 Posts: 12

Hi,

Which type of queries is more efficient Nested Subqueries or Joins?? Plz help.

Rgds,
Rima.

prasadvrk · Posted: Thu Aug 31, 2006 4:34 pm

I think joins are more efficient than the nested (specially correlated sub queries), though it depends on the requirement to choose between the two.

ashikrim · New User Joined: 18 Aug 2006 Posts: 12

Hi prasad,

Thanx for the reply.....How do v judge that??? I was asked in an interview whether joins or subqueries are better?? even i answered as joins but bases on the number of passes subquery was better comparitively. So how do v answer the above question...