I am using Ola Hallengren's scripts to maintain my databases. On a few of them there are indices that don't seem to be benefiting from the maintenance. I know that his scripts have a lower threshold (I believe 1000 pages), below which it will not attempt to rebuild or reorganize.
For one index, in dm_db_index_physical_stats the clustered index shows up on 2 lines. One is PK_DATA, allocation unit type of IN_ROW_DATA, 16 pages, and 93.75% fragmented. The other PK Data, allocation unit type of LOB_DATA, 57200 pages, and 0% fragmented.
Should I expect this index to be reorganized or is it being skipped due to the differing page counts for the different allocation unit types? Or might it be getting reorganized unsuccessfully?
Thanks in advance for any advice you might have.