I am creating a dashboard, and for example a Formula field will identify if the record has issues. I know that Formula fields are not indexed in SOQL. Can anybody tell what's the best approach in this case. The main issue is the loading time, because the query will return a large amount of records count().
I will appreciate any advises