Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    79

    Unanswered: Update stats slowing down SP

    I have a strange behaviour in my sybase database server. I am truncating a table and then do a bcp in and then I do update stats on that table and a SP is executed to update this table.

    When same SP is executed without update statistics, it takes 3/4 of the time which is taken with update stats.

    Will sp_recompile help in such a case ?

    Thx

    Wilson
    Last edited by Wilson77; 03-22-06 at 12:25.

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    In general you should run sp_recompile on the objects for which you run update stats. Otherwise the SP will use the query plan that was previously generated.

    Michael

Posting Permissions

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