We were all expecting that in SharePoint 2016, the List View Threshold would be changed, and yes, it has been changed.
List View Threshold changed from maximum 5000 items per view to greater than 5000 items. Yes, you are reading it correctly. Now, there are more than 5000 items in a view, but what is the upper limit?
Upper Limit
It depends on SQL hardware, SharePoint Server's hardware, and the structure of the site collections. Now, they have introduced new values for the following.
- List View Threshold
Greater than 5000. Specifies the maximum number of list or library items that a database operation has, such as a query that can process at the same time outside the daily time Window set by the administrator, during which queries are unrestricted.
- When adding or removing a column index, the threshold is 20,000 by default.
- When deleting a list or folder, the threshold is 100,000 by default.
- When renaming a folder within the same library, the threshold is 100,000 by default.
- List View Threshold for auditors and administrators will remain the same at 20,000.
- List View lookup threshold has 12 join operations per query.
Keep in mind that we still can change these values at the Web Application level.
With SharePoint 2016, MSFT introduced Auto Indexing, which is the large List View in SharePoint. This means, if List View Threshold is set at 5000 and an item reaches to 2500 in a list view, then SharePoint automatically indexes the column.
Reference