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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Index Rebuild

Author  Topic 

jai2808
Starting Member

27 Posts

Posted - 2011-04-05 : 03:05:01
Hi,
Wanted to know if we need to rebuild the non clusered index in our database using maintenance plan.

Will the indexes will not be updated when the data changes automatically.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-05 : 10:34:19
You should rebuild indexes as they become fragmented -- both clustered and nonclustered.
Go to Top of Page
   

- Advertisement -