Rebuild offline/online different results !! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Rebuild offline/online different results !!

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
]]>