• Before:

    IndexNameIndexIDIndexTypePartitionNoNumRowsInTypeNumPagesTotKBsUsedKBsDataKBs

    Pk__Key1CLUSTERED11770892LOB_DATA845812936766503446765902800

    Pk__Key1CLUSTERED11770892IN_ROW_DATA19946159568159448157520

    Pk__Key1CLUSTERED11770892ROW_OVERFLOW_DATA0000

    DK_2NONCLUSTERED11770892IN_ROW_DATA5834466724655244912

    And after:

    Pk__Key1CLUSTERED11770892LOB_DATA845812936766503446765902800

    Pk__Key1CLUSTERED11770892IN_ROW_DATA19946159568159448157520

    Pk__Key1CLUSTERED11770892ROW_OVERFLOW_DATA0000

    DK_2NONCLUSTERED11770892IN_ROW_DATA5834466724655244912

    And after the index rebuild:

    Pk__Key1CLUSTERED11770892IN_ROW_DATA10915873208727286392

    DK_2NONCLUSTERED11770892IN_ROW_DATA2546203682031220240