Forum Discussion

Dean_Gross's avatar
Dean_Gross
Silver Contributor
Feb 14, 2018

Limitations of Predictive Indexing

I noticed that automatic indexes were not present in several document libraries so I opened a ticket with MS Support (SRX618020694115495ID ) and they provided me the following explanation:    " I...
SharePoint Online
Kerem Yuceturk's avatar
Kerem Yuceturk
Icon for Microsoft rankMicrosoft
Oct 03, 2019

Hi micro99999, this is indeed a limitation for these types of columns due to how they are implemented. Here's the relevant piece from our support article:

Columns with column types people, lookup or managed metadata can cause list view threshold errors when sorting. However, text, number, date and other column types can be used in the first sort.

 

Hopefully it is possible to work around this by sorting by ID or another field of type text, number or date, and then using filters for these values?

PhoenixMS's avatar
PhoenixMS
Iron Contributor
Oct 03, 2019

Kerem Yuceturk 

 

Thanks for the reply. Just to verify, is it never possible to sort by managed metadata columns regardless of sort settings or indexes? For instance, the documentation states: "However, text, number, date and other column types can be used in the first sort." Does this mean a secondary sort may work?

Resources