Hallengreen's Index maintenance query not using all indexes I'm using Hallengreen's Index maintenance To reorganize/rebuild indexes on my databases.
The problem is, when I execute it:
EXECUTE dbo.IndexOptimize
@Databases = 'MyDatabase',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30

It only finds 2 or 3 indexes (On Messages Window). And I have a lot of them with more than 90% fragmentation:

Is there some information I'm missing?
Maybe there are not enough pages, so there's no performance impact, and then the script just skips the index ( the first index has 240 pages)?
There is a variable in the script. Something like 'do not rebuild indexes with less then 1000 pages' - this is the default.
Its name @PageCountLevel

You can change it to whatever you wish.