Fix view of displaying files in a document library with ~60,000 items

Question

I need to display all the files in a SharePoint Online document library with approximately 60,000 items.
However, the library is not displaying any files. I already attempted to create a new view with filters on indexed columns, but it did not resolve the issue.
How can I make sure all items - including folders, files, and files inside folders - are visible? Note that the library will continue to grow by about 400-500 items each month.

Answer 1

List view threshold is a limit of 5000 items in the SharePoint online, which can’t be exceeded. Even if a view has filters on indexed columns, the view must have less than 5000 items to ensure better performance.

The best choice to solve this issue is to create folders for each month in the document library, and in each folder make sure files are less than 5000.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Even if a view has filters on indexed columns, the view must have less than 5000 items to ensure better performance.

In this case where filters are applied on indexed columns, will the view break or will it just be slow?
What is the exact number of items in document library above which it will break?