Tweeted twitter.com/StackSharePoint/status/861626536843235328
2 updated the Tags for quick results
| link

When SharePoint list with 5000+ items queried with ID returns expected result but with any other column gives threshold error.

1
source | link

When SharePoint list with 5000+ items queried with ID returns expected result but with any other column gives threshold error.

I am trying to query a SharePoint list which has more than 5000 items. When I run filter query with ID, it returns the expected results. But when I run the same query with any other column it throws an error as shown below. enter image description here

I know that there is a threshold limit of 5000. But I want to understand why am I getting the values when queried with ID column and not with any other column.