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
Office 365
SharePoint
SharePoint 2016
sharepoint list index column
SharePoint Online
Supported and unsupported field 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.
No Comments