SharePoint list column added to list index to improve the column performance when filter content as it improves the performance of query operations which can include filters, sorting and joins on index columns. You can add single column index or two column indices for a list. Index column are similar to index column in database, but these are stored in SharePoint as they are Name value pair instead of SQL Server. You can not add an index column if no. of items in a list exceeds 20000 list items, so you need to add them before it crosses the 20K limit. You can add up to 20 indices for a list. Not all list

SharePoint list ID column is by default an index column. You can add single line text, number, date, Boolean and metadata fields as list item index. Whereas, you can add multiline text, Hyperlink/Picture and calculated fields to list index. Choice and Person or Group can be added to the list index if they are single value.

Below table shows the list of supported and unsupported field for list indexing

Supported Field Types Unsupported Field Types
Text (Single Line) Text (Multiline Line)
Choice (Single value) Choice (Multi value)
Person or Group (Single value) Person or Group (Multi value)
Number Hyperlink/Picture
Date & Time Calculated
Currency External Data
Lookup Custom Column
Managed Metadata  
Boolean (Yes/no)  

list index column supported and unsupported types

Adnan is six time Microsoft MVP (Since 2015) with over 16 years of extensive experience with major expertise on SharePoint, SharePoint based development, Microsoft 365, Microsoft Teams, .Net Platform and Microsoft BI. He is currently working Sr Microsoft Consultant at Olive + Goose. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past 12 years and worked on different intranet/intranet solutions for private & govt. sector majorly in United states and Gulf region and have experience of working with multiple Fortune 500 companies. He is a trainer, technology evangelist and also speaks in community forums.

Leave a Reply