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