sql

Using SQL Server Execution Plan to Optimize Performance and Build POC Index

A Quick Tip

Sometimes it may feel like optimizing your T-SQL queries can be a guessing game, but SQL Server provides some very simple tools you can use to analyze your queries.

Simply write your T-SQL query in SQL Server Management Studio and instead of hitting execute, hit CTRL-L.

This will open a new tab below, and show you the execution plan.

sql-server-execution-plan

In addition, it can help you build a POC index that can significantly increase performance.

P = Partitioning
O = Ordering
C = Coverage

sql-server-missing-index

And if you right click and choosing Missing index details, it will even give you the SQL needed to create your index and a estimation of how the index could improve the query cost.

sql-server-missing-index-creation

 

Leave a Reply