A report repeatedly performs the same eligible expensive aggregation, and bounded refresh behavior is acceptable. Which approach best fits?

1. Filter on the relevant partition column using a pruning-compatible predicate.
2. Evaluate clustering on the frequently filtered identifier and measure the effect.
3. Evaluate a compatible materialized view.
4. Perform a dry run and set an appropriate maximum bytes billed where supported.