Why index rebuild does not reduce index fragmentation
There may be 2 reasons for this. The first is that the index is less than 8 pages, and the second is that there is not enough space on the hard disk to rebuild. Less than 8 pages If an index is very small (less than 8 pages) it will use mixed extents...
Dec 17, 20231 min read26
