Post reply

SP_ATTACH_DB - need to update stats when??

  • September 23, 2004 at 11:42 am

    #85393

    I have a database detached from a SQLServer 2000 box.  When attached to another SQL 2000 box, is there a need to update stats? 

     

    I know when attaching a DB from SQL7 to SQL2k that this is necessary, but 2K to 2K?

     

     

  • September 23, 2004 at 12:13 pm

    #524234

    If you were moving it to another database, I'd say yes. If you are just reattaching the database to the same server and you want to take the time to redo the stats, then check DBCC SHOW_Statistics  on your biggest tables, and see how bad they really are. Also, if you are not using AutoUpdate stats on SQL 2000 databases, then I wouldn't bother to check either. I'd just do it because the database was down.

  • September 23, 2004 at 12:48 pm

    #524246

    Basic situation is this....

    Database held on our server, detached, and then shipped to a customer.  Customer attaches to their server.  Doing a full reindex would be overkill, as would Update Statistics xxx with Fullscan.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply