Hello

This is a production database. I am not allowed to drop indexes and create them from scratch.

I guess the previous reply is correct to assume. He said when the

number of pages is less than 1000, SQl server does not bother to defragment the index ( I mean that part of the index that sits on level 2 )

I am going to do a few more ( I mean index rebuilds ) today and find out whether the results are consistent with what he says.