How to Add an Index to a SharePoint List or Library Column

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.

Related articles:

• How to Reindex a SharePoint Document Library to show the correct results : ShortPoint Support 
• ShortPoint Connect: Basic Tutorial : ShortPoint Support