DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

10
Shouts

Shout it

SQL Query Optimization FAQ Part 1 (The SQL Plan)

published 1206 days, 23 hours, 3 minutes ago posted by

questpond 1210 days, 7 hours, 57 minutes ago

SQL Query Optimization FAQ Part 1 (The SQL Plan)

In this article we first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index scan clustered scan etc. As we understand the logic of these operators we will also try to understand what are the best practices in different situations.