How to increase performance of Sql ?

Question

Hi there , Could you please help me how to optimize sql query Thanks in Advanced

Sonu Gupta · Answer

Hi Siddharth, Take care the following things to improve the query performance- 1. Check the execution plans and identify slow running queries 2. Use the parameter sniffing 3. Avoid the using sub query 4. Avoid the using SELECT *FROM 5. Use SET NOCOUNT ON 6. Use NO LOCK 7. Create Proper Index 8. Avoid the using ISNULL in where condition 9. Avoid the unnecessary Joins 10. Force to recompiles (use the WITH RECOMPILE) I hope its solve your problem....

Harsh Gupta · Answer

Hi Siddharth, Please refer to the below URL, you will get 25 tips to improve the performance of the query. https://www.winwire.com/25-tips-to-improve-sql-query-performance/ Thanks

Amit Mohanty · Answer

Ways to Improve SQL Query Performance 1. Avoid Multiple Joins in a Single Query. 2. Eliminate Cursors from the Query. 3. Avoid Use of Non-correlated Scalar Sub Query. 4. Avoid Multi-statement Table Valued Functions. 5. Creation and Use of Indexes. 6. Create a Highly Selective Index. 7. Position a Column in an Index. For more details check the below links https://www.c-sharpcorner.com/UploadFile/f0b2ed/tips-to-increase-sql-server-query-performance-part-1/ https://www.c-sharpcorner.com/UploadFile/f0b2ed/tips-to-increase-sql-server-query-performance-part-2/

Rajanikant Hawaldar · Answer

Reducing the amount of data that is returned, by only returning the fields required and only returning the rows required. This is the most common, as you do it for every query that returns data. Adding indexes. This is not done as frequently, as some tables doesn't need any other index than the one created for the primary key go through this thread it contains so many threads discussions on query optimization. https://stackoverflow.com/questions/tagged/query-optimization https://stackoverflow.com/questions/3191623/how-to-optimize-queries-in-a-database-the-basics https://medium.com/@erickmendonca/basic-tips-on-tuning-sql-server-queries-f834f09bafaf