I have a query about the List view threshold on SharePoint 2013 where the limit is set to 5000 items in Central Administration.
We have a document library with 150,000+ items which means currently we have to set the item limit in CA to 200,000 which obviously is not helping the SQL side of things.
This document library has documents that people need to access on a daily basis and it could be any number of documents in there that are accessed.
I've read up on indexing columns and setting item limits in views however unsure how this would work in our scenario as we don't want it to only return a listing of certain amount of documents in the list.