We have a list with ~6000 items and an indexed column
There are two filtered views:
Items Younger Than 30 Days
Greater Than [Today] - 30
This view works correctly.
Items Older Than 30 Days
Less Than or Equal [Today] - 30
This view throws a list threshold error.
About half of the items were created before last month.
Can someone please help me identify the reason why "Younger" works and "Older" fails?
One hypothesis is that the Less Than query may not be not SARGable in the way that the Greater Than query is (see below link). If SP is attempting to evaluate all 6k rows, not just the bottom 3k, perhaps that pushes us beyond the limit. reference