TechRepublic|Forums|Google

Google

Question

  • Creator
    Topic
  • February 24, 2009 at 10:20 pm #2169550

    SP Optimization

    Locked

    by ashok · about 15 years, 9 months ago

    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

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • February 24, 2009 at 10:20 pm #2765227

      Clarifications

      by ashok · about 15 years, 9 months ago

      In reply to SP Optimization

      Clarifications

    • February 25, 2009 at 12:11 pm #2763154

      The techniques for optimising an sp

      by tony hopkinson · about 15 years, 9 months ago

      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.

  • Author
    Replies
Viewing 1 reply thread