Its SharePoint online. We have indexed all the column which are being used to filter/query.
A total number of items in the list are around 100 thousand.
Filter works perfectly fine. e.g. if we search/filter with the title that contains W, it works fine and returns around 400 records out of 100 thousand.
the challenge is , if the filter is "Title contains a" then it returns around 12k items and gives standard threshold exceeded error.
is there any way to handle this. AFAIK indexing was the only option.
I had read somewhere this limit is going to be increased from 5000 for SharePoint online? any idea?