What a materialised view trades away

• A

  Correctness, since aggregates over a copy may differ from the original

• B

  The ability to index the result

• C

  Nothing, since the refresh keeps it in step with the base tables

• D

  Freshness: the dashboard can be up to an hour behind the base tables