June 1, 2009 at 2:17 pm
Im looking for a book or an article that explains the performance ins and outs of using keywords such as UNION, UNION ALL, DISTINCT, GROUP BY, ORDER BY etc.
I know how to use these keywords in queries, but their impact on performance is an area im lacking. are there any definitive books or blogs i should look at? ive done a google search but cant find anything specifically on the topic.
Thanks all.
June 2, 2009 at 6:29 am
I don't know if you'll find a single article that contains information on all those key words specifically as they relate to performance. Mainly because they affect performance in such different ways. GROUP BY and DISTINCT are aggregators. So an article on aggregation will cover them, but it might not cover UNION or ORDER BY.
There are several books that include most or all of these as part of performance. I know of one (look down) that has them. The Inside SQL Server series has several books that cover them. There are others.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply