Does IndexOptimize doesn't really consider all indexes?

[iuridosanjos]

In my database, I got over 300 indexes that have > 30% fragmentation, checking running the following script:

SELECT S.name as 'Schema',
T.name as 'Table',
I.name as 'Index',
DDIPS.avg_fragmentation_in_percent,
DDIPS.page_count,
i.type_desc 'Index_Type_Desc'
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id
INNER JOIN sys.schemas S on T.schema_id = S.schema_id
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id
AND DDIPS.index_id = I.index_id
WHERE DDIPS.database_id = DB_ID()
and I.name is not null
AND DDIPS.avg_fragmentation_in_percent > 0
ORDER BY DDIPS.avg_fragmentation_in_percent desc

Then I run the the IndexOptimize in the simplest way to fix the fragmentation of all indexes:

EXECUTE dbo.IndexOptimize @Databases = 'PRIME_GENEONE',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30

First time I've executed it, the message shows some indexes being repaired, but after it finishes I run the first script again and it still shows over 300 indexes with >30% fragmentation. So, does the IndexOptimize script is ignoring most of the indexes (at least in my case)?

Note: all the indexes are nonclustered or clustered. None of them are ColumnStore (I've found some discussions talking about a possible bug over this type of index).

[iuridosanjos]

I've seen that the "problem" was the @PageCountLevel, as it's default is 1000. Most of my indexes page_count was < 1000. So there's no problem.