Question

Ways to Optimize Stored Procedure
How to optimize stored procedure?

Answer 1

here are few things  which need to consider while creating stored procedure.
1- try to use inner join always wherever possible instead of left outer join or sub queries.
2- always use Case statement instead of if else block.
3- use proper and strong binding and relations between tables.
try to minimise use of temporary tables as temporary tables kill performance.
4- if and temp table created then try to drop table always after use.
for more details contact me on [email protected]