Avoiding Nested Queries

Posted by Midhat on Stack Overflow See other posts from Stack Overflow or by Midhat
Published on 2010-05-06T06:02:38Z Indexed on 2010/05/06 6:08 UTC
Read the original article Hit count: 285

Filed under:
|
|

How Important is it to avoid nested queries.

I have always learnt to avoid them like a plague. But they are the most natural thing to me. When I am designing a query, the first thing I write is a nested query. Then I convert it to joins, which sometimes takes a lot of time to get right. And rarely gives a big performance improvement (sometimes it does)

So are they really so bad. Is there a way to use nested queries without temp tables and filesort

© Stack Overflow or respective owner

Related posts about sql

Related posts about mssql