Microsoft's SQL Server has a handy command that rebuilds all indexes in a table. Oracle users typically rebuild each index in a table individually.

Before SQL Server 2005, we would always use DBCC SHOWCONTIG to identify fragmentation in indexes. We would use DBCC INDEXDEFRAG to perform an online defrag and DBCC DBREINDEX to rebuild indexes ...

As part of my weekly maintenance routine, I rebuild the indexes on several of my larger high-activity tables. I'd like to try and get an idea of just how long the rebuilds take. The rebuilds are ...