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

Privacy Settings
Name Enabled
Cookies
We use Cookies to give you a better website experience.
x

We use cookies to ensure the best possible experience on our website. Detailed information on the use of cookies on this site is provided in our Privacy and Cookie Policy. You can also manage your preferences there.