#1 The table is very large ( well above a million rows ).

#2 If the page count in small ( less than 1000 ) you said it would not fragment. So why does it then give a 100% ?

Take a look at the output. At the index level 1 it is 0%

This is clear since there is only one page involved.

If you say that since the page count is small ( less than 1000 ) why did it say 100% ? It could have said 0% as well?

Also before I ran the "Alter index command... " I didn't see 100% on any of the indexes at any level ?

This is confusing ?