rgivens

data_engine and automatically reindex tables

Discussion created by rgivens on Nov 18, 2009
Latest reply on Nov 18, 2009 by 1_tim.moor
I was thinking about enabling the automatically reindex tables option on the data_engine but have a couple of concerns about doing this.  Is anybody familiar with how the reindexing happens?  Does it reindex all tables all at once or does it go through one table at a time?  I'm concerned about log file growth if it were to reindex all tables at the same time. 

Also, our database is SQL 2005.  Does the reindex job use the online reindex feature of 2005?

Outcomes