I have migrated a WSS 3.0 farm to SP Foundation 2013. One list has 6500 items. No view will display unless I raise the threshold to > 6500. Test view is filtered on one indexed column that displays only 3700 items when the threshold is raised. When I lower the threshold back to 5000 it fails with the standard threshold exceeded message. I have no sorting or grouping in the test view.
I have searched endlessly and all research says that this view should work. What am I missing? I migrated the list items and then created the indexed columns. Shouldn't that have worked? The list has been added to extensively since the original migration. I have deleted and recreated the indexed column. Any ideas?