There’re a few solutions, but what to choose depends on whether you have the database version that lets you set a filter (I think it’s a beta feature and it’s not released to globally to everyone).
Please let me know if you have this feature first.
See:
https://support.wix.com/en/article/content-manager-adding-an-index-for-your-collection