Increase Performance Of Stored Procedure

Question

How we can Increase The performance Of Our Stored Procedure

Manish Dwivedi · Answer

Hi Rahul We can increase performance of stored procedure by writing this line in the SP. Set NoCount ON. If there are lot of records in the table then u can use paging of the Sql Server for improving the performance of the SP. Or create index on the table. Happy Coding!!

Rahul Saxena · Answer

We use stored procedures to enhance the performance of database applications. Stored Procedure are precompiled and preoptimized and offer some programmable functionality. We can Increase the performance of Stored Procedure by doing these three tips Use NOCOUNT Use return values Optimize table access with NOLOCK