I have ran the following query to view the fragmentation on my large table with 1000+ pages.
Now the results I got are moslty at index level 0 and 1 and most objects are fragmented 90+%.
My question to the experts is that the query is displaying fragmentation mostly at Index level 0 and 1. Do I need to look or just Level = 0 is fine?
The query is
SSI ON SDDIPS.OBJECT_ID
= SSI.id AND
> 1000 AND
avg_fragmentation_in_percent > 15 AND
View Complete Post