This article will show you how to add an index to a SharePoint list or library column. Adding an index may also fix ShortPoint connection issues and increases the performance when you use filters. It's also recommended to add indexes to the most commonly used columns which you are using to filter data.
TABLE OF CONTENTS
- Before we begin
- Step 1. Go to SharePoint list or library settings
- Step 2. Add/Create an index to your column
Before we begin
This solution is for you if:
- You use Office 365 or SharePoint 2019 environment.
- You have at least Edit Permission on your SharePoint site(s).
Step 1. Go to SharePoint list or library settings
For SharePoint List, click the Cog icon/Settings on the upper right side of your page and select List Settings.
For SharePoint Library, click the Cog icon/Settings on the upper right side of your page and select Library Settings.
Step 2. Add/Create an index to your column
Scroll down to the Columns section and select Indexed Columns
On the Indexed Columns page, hit the Create a new index
Select the column you wanted to add an index under the Primary column for this index then select Create
Note: Kindly make sure that you are selecting a supported columns. To know more about the supported columns, you may visit this article.
That's it! You can now check your design elements connected to a SharePoint List or Library view that has filters. In some cases, it may take an hour or two for the index to be fully applied.