Quetion about Page field in Index Properties?

  • What does the Pages field mean on the Fragmentation Page under Index Properties. Is that the number of index pages from page splits and is it a lower number good or high number good? Thanks

  • Pages is literally the number of pages that make up the index. Smaller numbers just mean fewer pages. If your index is seriously fragmented, that number may be a lot higher than it will be after you reorganize the index.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply