Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-02 : 09:08:32
|
| Doug writes "Is there any maintenance recommendations or guidlines for performing periodic reindexing? I have a customer, who was running our CRM application, using SQL 7, and since reindexing one of our applications tables in the SQL DB it has reduce the time a query takes on this table, and has also stopped them seeing C++ Runtime errors they got when their CRM clients applications ran queries on this table. The concern now is that as this table grows, the query will take longer re introducing these runtime errors.So if there are recommendations of how often re indexing should occur, and if indeed it should be part of the DBA maintenance proceddures please let me know!Thanks & Rgds." |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-02 : 10:15:13
|
| Look at http://weblogs.sqlteam.com/tarad . She has a script to run reindexes. You should schedule it to run a minimum of once a week. If you have a big enough maintenance window at night, I would run it every night.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Server Re-Indexing