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)?