An expensive repeated query pattern may benefit from a materialized view. What tradeoff must be evaluated?

Published
  1. They automatically accelerate every possible query
  2. Stored results and maintenance compute versus query savings
  3. Materialized views have no storage or maintenance cost
  4. They eliminate the need for source-data privileges in every context

Comments — 0