Fritchey Grant. SQL Server Execution Plans

2nd Edition - Simple-Talk Publishing, 2012. — 332 p. Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: - Which indexes are being used, and where no indexes are being used at all. - How the data is being retrieved, and joined, from the tables defined in your query. - How aggregations in GROUP BY queries are put together. - The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans.