REINDEX - Tabla de comportamientos de reindex

TABLA DE COMPORTAMIENTOS DE REINDEX

Scenario	SQL Server 2008 R2	SQL Server 2008	SQL Server 2005	SQL Server 2000
DBCC REINDEX to rebuild the Clustered Index ix_Col1	Update all Index Statistics	Update all Index Statistics	Update only the Clustered Index	All statistics updated
DBCC REINDEX in the NonClustered Index	Update only the NonClustered Index	Update only the NonClustered Index	Update only the NonClustered Index	Update only the NonClustered Index
DBCC REINDEX without specify the index. That means all index must be updated	All statistics updated	All statistics updated	All statistics updated	All statistics updated
ALTER INDEX REBUILD to update the Clustered Index	Update only the Clustered Index	Update only the Clustered Index	Update only the Clustered Index	Not Apply
ALTER INDEX REBUILD to update the NonClustered Index	Update only the NonClustered Index	Update only the NonClustered Index	Update only the NonClustered Index	Not Apply
ALTER INDEX ALL REBUILD to update the ALL Index	Update all Index Statistics	Update all Index Statistics	Update all Index Statistics	Not Apply