I have a list with 10,000 items. The list view threshold is 5,000. The list has an indexed lookup column. There is a view that should return about 400 items:
My Column (indexed) is not equal to Sample Text
However, I get an error:
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
The view should only return 400 items, so why am I getting an error? Is it because I'm using a lookup column to filter (if yes, please link to a reputable source stating that this is the case)?