SP Optimization

Hi friends,

Is any tutorial or useful link for stored procedure optimization with example.

I searched in google.But it is not enough. Please if you know send me,

Hope your's reply.

Thanks & Regards

(Based on SQL Server)
Using and understanding the execution plan is a good start.
Also SQL Profiler is a useful tools as well.

Seme SQL Server Stored Procedures Optimization Tips
http://www.databasejournal.com/featu...ation-Tips.htm

Execution Plan Basics
http://www.simple-talk.com/sql/perfo...n-plan-basics/

Of course if its not SQL Server you are using it will be worth letting us know what database backend your question relates to.

Do you have any specific problem Stored Procedures or is this just a general question ?