Optimizing Indexes with Sql Server 2005 (Yukon) Beta 2
If you want to optimize your indexes in Sql Server 2000, you probably used the DBCC REINDEX or DBCC INDEXDEFRAG commands. I like the DBCC INDEXDEFRAG because I don't have to take the table offline from the application. I've been looking at for a similar mechanism in Sql Server 2005 (Yukon). I have found the ALTER INDEX command. The advantage that it has over the DBCC INDEXDEFRAG command is that with a DBCC INDEXDEFRAG command, you must manually specify the indexes that you want to defrag. Why am I looking for this? According to the documentation, DBCC INDEXDEFRAG will be removed from a future version of Sql Server.
Wally