August 26, 2005 at 7:53 am
I am just curious how many of you agree/disagree on this. Your input is appreciated.
It's about index defrag. Would you normally check the de fragmentation using Showcontig and then rebuild/defrag the index or directly rebuild/defrag index with out running the showcontig. I prefer the first one, rebuild indexes.
Thanks
Shas3
August 26, 2005 at 8:41 am
It depends on lots of factors, such as down time, server load, table size etc.
Defrag is online operation has samll impact on other transactions. Reindex one table is one big transaction and will block other processes that try to access this table. If the table is big, you can only do it in down time.
If your database has consistent transaction load every day, you do not need to check the fragmentation. You can schedule the reindex/defrag at a proper time, say weekly becuase ShowContig takes sometime on big tables.
August 26, 2005 at 10:56 am
I don't run showcontig first. I know my database has LOTS of INSERTS (no UPDATES). Very seldom are there DELETEs and they are only done by me. But when I do them, there are lots of them. After deleting a couple of months worth of data (about 1 million records a day), I do a defrag.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply