data/indexer: optimize clickhouse queries #2692
Description
Optimize some of the more expensive clickhouse queries, and materialize some views if necessary.
{{ message }}
Optimize some of the more expensive clickhouse queries, and materialize some views if necessary.