Also, look into a few of the other DBCC commands that force the database to check itself and reset the statistics. I think DBCC Statistics or something like that will regenerate the statistics for each table.
Since your production tables may have a completely different ratio of inserts/deletes to updates, etc., it is possible that the statistics that manage where the data is, and hence how the tables are indexed, etc. may be really out of whack. FYI, the reindexing and statistics MIGHT require that your database be in single user mode, I know that some of the table verification/corruption checking checks require this. If so, you pretty much have to disconnect everyone and all processes from the server in order to run them. There are some flags that you can flip that will force people off of the system. I have these commands written up at work if you need them sometime Monday or Tuesday. Ryan ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
