In this post we will discuss about SharePoint 2016 List view auto indexing feature. In SharePoint 2013 Microsoft has set a default threshold limit of 5000 items for 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.
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.
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.
