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

1 solution

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

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

SQL Server Profiler Step by Step[^][^]

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

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