Results 1 to 3 of 3

Thread: PERFORMANCE OF STORED PROCEDURES

  1. #1
    Eric Guest

    PERFORMANCE OF STORED PROCEDURES

    I`ve written a pretty complex powerbuilder application and my performance
    is fair use stored procedures. Is there any way to force sql server 6.5
    to reevaluate the current query plan and if it is bad create a new
    query plan.

  2. #2
    Sanny Y. Guest

    PERFORMANCE OF STORED PROCEDURES (reply)

    I don`t know of any way for SQL server to make that decision, to reevaluate and create a new query plan , but I know u can set Show Query Plan on and see if there is any way for you to improve the query, see if using indexes would be helpful.

    Sanny

    On 7/31/98 2:35:31 PM, Eric wrote:
    > I`ve written a pretty complex powerbuilder application and my performance
    >
    is fair use stored procedures. Is there any way to force sql server
    > 6.5
    to reevaluate the current query plan and if it is bad create a new
    query plan.

  3. #3
    Guest

    PERFORMANCE OF STORED PROCEDURES (reply)

    Create SP using the WITH RECOMPILE option. (It’s going to affect performance a little bit)
    Or use `sp_recompile tabname` once in a while (once a week).
    Read about this in MSSQL Books Online.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •