id="info"

Question

Locked

SP Optimization

By ashok ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

The techniques for optimising an sp

by Tony Hopkinson In reply to SP Optimization

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.

Back to Google Forum
2 total posts (Page 1 of 1)  

Brands Forums