Remove the limit of 5000 items as result in a view
You can have millions of items in a list, but as soon as the view you are using returns more than 5000 ítems then you get an error, the only solution is to create filters and indexes to this view, and it has to be done before reaching the 5000 ítems limit, otherwise there won't be a way to create the indexes / filters.
I know about this workaround because I created a support case in Microsoft Premium, here you have the reference: [REG:116022413747778] Sharepoint History list has been lost or can't be seen
Apologies for late update here. We’re going to close out this suggestion, directing folks to recent updates we shared at Ignite 2017 around smarter indexing and UX improvements to better manage querying and displaying content from large lists (for more details check out this Ignite session: https://myignite.microsoft.com/videos/53861). For specific scenarios or feedback on this approach please post new suggestions (noting that SQL will never scan more than 5k rows, so specific feedback/suggestions where the current approach still blocks scenarios would be welcome). Thanks!