SharePoint List Index Column

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

The following two tabs change content below.
Adnan Amin
Adnan is two time SharePoint MVP (Most Valuable Professional) with over 12 years of extensive experience with major expertise on SharePoint Server, Office 365, .Net Platform and Microsoft BI. He is currently working SharePoint Architect at FMT Consultants. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past nine years and worked on different intranet/intranet solutions for private & govt. sector majorly in Gulf region, which include OOB and customized solutions. He is a trainer, technology evangelist and also speaks in community forums.

Leave a Reply