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
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
by ashok Accepted solution
by tony hopkinson Accepted solution
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.
Sort by Trending