Click here to Skip to main content
15,917,645 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have greater than 3000000 records in single table so my sql querys taking 1 minutes .

how to Increase Stored Procedure Performance
Posted

1 solution

Follow below link for best practice to increase Stored Procedure performance:

http://blog.sqlauthority.com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/[^]

Use SQL Profiler to catch your slow running queries and re-mediate it:

SQL Server Profiler Step by Step[^]

https://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/[^]

Secondly if you are joining with large table then create a non-clustered index which column is used in joining query.
 
Share this answer
 
Comments
Maciej Los 2-Oct-15 7:45am    
+5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900