SQL Server Performance

Rebuild offline/online different results !!

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by alzdba, Jun 14, 2006.

  1. alzdba Member

    Aparently optimisation level of a rebuild index in SQL2005 differs when executed offline or online ! ?? [V][?][B)]

    I've got this table with 3 indexes (1clx 2ncx) wich results in 0% fragmentation for all indexes when executed offline. When executed online it leaves the ncx with +/- 20% fragmented ???!!!

    ALTER INDEX all ON [BST].[T_ITEM] REBUILD;

    ALTER INDEX all ON [BST].[T_ITEM] REBUILD WITH ( ONLINE = ON );

    SQL Server 2005 EE X64 with sp1

Share This Page