The requirement is to provide column indexing in every list and libraries in the SharePoint Online Site.
Library
Which Primary and Secondary Columns need to be indexed for library ?
List
Which Primary Column needs to be indexed for list ?
Hello @sajithgh ,
I agree with @trevorseward, we cannot provide you with a clear answer.
Indexing columns - before the threshold limit is broken - is the most effective way to mitigate View threshold pain. In an ideal situation, where the user knows the List or Library will be large, you'd index any and all columns you can.
Adding an index to a list or library column increases performance when you use filters. You can add indexes on up to 20 columns on a list or library. While you can add up to 20 indexes per list or library, it's recommended you add indexes to only to the most commonly used columns and on those columns which you are using to filter data both in views as well as using the column headers. Indexes add overhead to the data so use them only where they make sense to be used.
For more infoemation, you can see the "Add an index to a list or library column".
Thanks,
Echo Du
============================
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
We can't provide you with a direct answer. You should index column(s) you're using in a View for Filtering purposes. Most indexes likely won't have a second column. If the list is large enough (>2500 items), SharePoint will automatically create indexes as needed based on the current views of the list.
Creating an index just to create an index won't do anything for you. You need to then leverage that index in a filter on a view.
4 people are following this question.
