Posted by John Bell on 03/11/07 10:36

Hi Rob

"rcamarda" <robert.a.camarda@gmail.com> wrote in message
news:1173578291.621286.217970@p10g2000cwp.googlegroups.com...
> thanks John:
> Result of one trouble file (tab delimited).
> alloc_unit_type_desc index_depth index_level
> avg_fragmentation_in_percent fragment_count avg_fragment_size_in_pages
> page_count
> IN_ROW_DATA 1 0 33.3333333333333 12 11.1666666666667 134
> IN_ROW_DATA 2 0 88.2352941176471 16 1.0625 17
>
> Based on your points about BOL, I found a script the reindex, or reorg
> the index, but I still have files upwards of 80% fragmentation.
> This is an undiscovered country for me, thanks for the guidance!
> Rob
>

There seems to be some columns missing! Can you also post the DDL for the
table and indexes.

John

[Back to original message]