IndexOptimize - Skip large indexes from the query to dm_db_index_physical_stats

[psbradshaw23]

Hi,

Re: the IndexOptimize stored procedure.

I would like to maintain the index fragmentation of the smaller database indexes many times per day leaving the larger index maintenance to run once a day, and for the very large indexes once a week.
I would like to be able to use the MinNumberOfPages and MaxNumberOfPages to control which indexes are being managed.
Unfortunately the test for the number of pages happens after the query to dm_db_index_physical_stats has done it processing on the indexes, as such, to maintain even the smaller indexes takes many hours as it spends time querying dm_db_index_physical_stats before it works out whether the index is appropriate for the run parameters. Can anyone think of a way to skip the large indexes from the query to dm_db_index_physical_stats?

Paul.