SharePoint 2016 List View Auto Indexing Automatic Index Management

sharepoint 2016 new feature listview threshold

In this post, we will discuss SharePoint 2016 List view auto indexing feature. In SharePoint 2013 Microsoft has set a default threshold limit of 5000 items for the SharePoint list. Once the threshold limit reached, you will get an error message saying “The number of items in this list exceeds the list view threshold”. You can check out more in this article.


SharePoint 2016 also has the same threshold limit of 5000 but it made few enhancements to it so that user will not face any error even if the threshold limit reached.

Also, read:
SharePoint Online Step by Step Tutorial on how to create a new custom master page by using existing master pages in SharePoint Online

Creating fixed width master page in SharePoint 2013

Get Users from SharePoint Group using JavaScript Client Object Model

In SharePoint 2016, they introduced this new feature known as “Automatic Index Management” which works with a new timer job “Large list column index management Timer Job” to resolve the threshold issue.

FREE Download SharePoint Server 2016 Installation PDF Guide

Automatic Index Management setting is available for each list. The settings can be enabled or disabled from List Settings -> Advanced Settings -> “Automatic Index Management”. By default for all list and library, the property is enabled.

SharePoint 2016 List View Auto Indexing Automatic Index Management
SharePoint 2016 List View Auto Indexing Automatic Index Management

Once this property is enabled, then the timer job roles came.

SharePoint
2016 introduced a new timer job known as “Large list column index management Timer Job” which is responsible for auto creation of indexes when required on various views within each list in SharePoint 2016.

We can see the timer job from Central Administration -> Monitoring then click on Review job definitions which is under Timer Jobs.

sharepoint 2016 new feature listview threshold
sharepoint 2016 new feature listview threshold

The above timer job runs daily and it searches for lists whose Automatic Index Management is enabled and which list exceeds 2500 items. And when it find a list that has a view definition that could benefit from setting a index on a column, it will automatically created this index.

According to Microsoft “For example, if a view includes a filter for “WHERE A=1 AND B=2″, the Timer Job will create an index on either column A or column B. The specific choice depends on the other view definitions in the list, with the goal of minimizing the number of indexes created.”

Enable/Disable Automatic Index Management using PowerShell:

We can also enable or disable Automatic Index Management using PowerShell.

Enable Automatic Index Management using PowerShell:

$web = Get-SPWeb http://mypc/sites/MySP2016SiteCollection/
$list = $web.Lists[“MyEmployees”]
$list.EnableManagedIndexes = $true
$list.Update()

Disable Automatic Index Management using PowerShell:

$web = Get-SPWeb http://mypc/sites/MySP2016SiteCollection/
$list = $web.Lists[“MyEmployees”]
$list.EnableManagedIndexes = $false
$list.Update()



Hope this article will be helpful.

Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →