The Filters tab allows you to select additional criteria for this policy to evaluate the selected indexes.
What additional evaluation criteria is available?
You can choose from the following additional filters for your policy.
Page Count
Set the minimum and maximum ranges to dictate the size of the indexes selected. Indexes with small page counts do not benefit as much from defragmentation because query optimizers often use table scans instead of indexes.
Operation Order
Choose the order in which the optimization occurs for the qualified indexes.
Qualifying Indexes
Select a top number or percentage of qualified indexes to decrease the number of indexes optimized.