SharePoint: Use indexed column to improve SharePoint large document library or list access

Tag: The lock type will enter int into COM ima with the form

More and more enterprise users are using SharePoint on premise server or SharePoint Online as the enterprise data management and collaboration platform between the team, but with the enterprise development, the various types of data storage will be more and more, If the SharePoint administrator or user refers to the information stated in the official Microsoft article: supporting storage of 3 Million items/documents in a document library or list, and no long-term planning for a large archive or list, end Users will face the following 2 dilemmas in their future use:

? End users 很难在众多Items/Documents查找自己所需要的? 大文档库/列表访问和读取数据性能较差

Solution: Plan ahead, create a new indexed for your document library or list column,end users can use indexed Column in the Filter or sort option to quickly get the documents/items you want, thereby improving the performance.

Description: SharePoint on Premise, by default, the list View Threshold displays the list of items, exceeding that limit, which is blocked when the event occurs that the SharePoint administrator can Threshold limit is changed in administration, and SharePoint Online has no way to change its limit value.

Taking the document library as an example, the steps to use indexed columns are as follows:

1. 进入文档库->Setting界面，在Columns选项卡中，点击Indexed Columns，如所示：

2. 在Indexed Columns界面，点击 Create a new index，如所示：

3. 以Division Column为例，在Primary Column for this index 处选择：Division，如所示：

4. 返回Indexed Columns界面，可以看到Division Indexed已经新建完成，如所示：

5. 在View Setting中，以Filter setting为例，可以设置以Division=QA 进行过滤，如所示：

6. 切换新建的Division View，可以看到界面仅显示Division是QA的文档，其他文档已经自动过滤了，如所示：

Description

1. List of column that supports and does not support indexing

2. 一个Library和List仅仅支持创建20个Indexed columns

Thank you for reading ~ ~

SharePoint: Use indexed column to improve SharePoint large document library or list access