In this Article , we will explain step by step technique to optimize the query in SQL Server Management Studio.
Here we will fix bad queries and resolve performance problems of queries.
Lets Suppose we executed the SQL query and used that in application and checked-in into TFS.
Clients execute the application at their end and see that the application taking more time to run it then they will inform to you to see the optimization part of the query.
You should follow the below steps to optimize the query in easier way :
Step 1: First you need to select “Include Actual Execution Plan” and then execute the query.
Step 2: You will see that Execution Plan is generated after the Message Tab.
Step 3: In this Tab, There is some warning of missing index which is very useful to improve query performance.
Step 4 : Now, Right click on this warning and then click on Missing Index Detail.
Step 5: Once You click on Missing Index Detail, New tab will be opened to create missing index.
Step 6 : Once You create the index then Suggested index will provide approx 94 % improvement to your query.
If performance is still not good , You can add the INCLUDE columns which would be the logical for next steps.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.