dbcc indexdefrag moves all pages on a NEW index

[vadimg]

hey all!
i posted this about a year ago -- nobody replied...
so, bump....

Hope someone can explain the following phenomenon:

After creating a new index, running DBCC INDEXDEFRAG on this index will move ALL(????) pages in the index (Pages Scanned = Pages Moved). If DBCC indexdefrag is executed again, Pages Moved = 0 which is expected.

Question is: why would indexdefrag move every single page on a NEW index while it hasn't been fragmented at all???
If I run a dbcc showcontig on that index, I will see the scan density of 100%.

 

[JayKusch]

Are we talking about a clustered, non-clustered or either type of index this type of senerio happens?

Thanks

J. Kusch

 

[vadimg]

happens to both clustered and nonclustered indexes

SQL2K SP3
Windows 2000 Advanced Server