Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696

    Unanswered: dbcc indexdefrag

    Is there a reason why the first run of a sproc/query would be unusually slow after a dbcc indexdefrag followed by and update statistics ?

    I something done with the query plans/optimizer during this process ?

    We have a process that takes 45mins ff an indexdefrag, 6 mins thereafter.

    2KSP3

    Thanks,
    Paul
    Last edited by PMASchmed; 09-20-06 at 12:38.

Posting Permissions

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