Paul,

Please correct me if I'm wrong. Kalpesh's output show 0% logical frag
(perfect index scan performance) and 99.5% page density (terrific IO
performance). However the extent frag is 99.5%. Assuming he's on a
RAID disk array or SAN -- should Kalpesh worry about this? Is the
disparity between logical and extent fragmentation -- caused by using
DBCC IndexDefrag? Will DBCC DBReindex make logical and extent
fragmentation more in line with each other?

Thanks.