Lynn Pettis (5/26/2013)
Not necessarily. I would add the following columns to your query: ps.page_count, ps.avg_fragment_size_in_pages.
Here's some results with the extra columns...I take it you asked for these to make sure the indexes didnt just have 1 page?
nameavg_fragmentation_in_percentpage_countavg_fragment_size_in_pages
I_AGENT_SYSTEM_LOG_1_COMPUTER_ID_PLUS75.12194742883539007981.31537922373762
I_SERVER_CLIENT_LOG_1_CLIENT_ID83.18600332432183591711.18837927976813
I_SERVER_CLIENT_LOG_1_LOG_IDX99.22318898576143398511
I_AGENT_TRAFFIC_LOG_1_LOG_IDX99.21425143953941833921
I_AGENT_TRAFFIC_LOG_1_TIME_PLUS56.55940662310091813351.71507613733094
NULL40.516415049125313235617.1467806710714
NULL99.8127340823971152908.00958732805335
I_AGENT_BEHAVIOR_LOG_1_LOG_IDX99.24384638326991139981
I_SERVER_CLIENT_LOG_1_TIME30.37259465894351125623.18376467260642
I_SERVER_CLIENT_LOG_1_ID99.21343748588971107351
Do you know what the NULL index name represents? Table fragmentation?
Dird