Jaa


Interpreting SQL Server execution plans

As many of you may know, most of the time performance problems with SQL server come from bad queries/execution plans. That is why it is important to know how to interpret them. Most of you are likely peeked on graphical execution plans in SQL Server once or twice and familiar with physical operators for index seeks, table scans and joins but there are much more operators. In case you ever wondered or looked for a complete list of operators SQL Server implements here it is from deep inside of SQL Server documentation - books online. I personally find it very handy as it helps me to understand what SQL server does to return results and how to improve my query... 

 Hope you find it useful too