Question Locked

SP Optimization

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tony hopkinson

are exactly the same as those for a query.
Well in terms of what it does anyway.
There's no hard and fast guide on how to optimise, and aside from illustrating a few tips, an exanple is going to be near usless.

If it's SQL Server, this is the best sight I've seen.

http://www.sql-server-performance.com/

Optimisation is more of an art than a science, aside from some general tips like index your tables and such, most of it is intuition and suck it and see.

This discussion is closed to new replies.