Materialized views are often employed in query optimization to store _______.

  • Aggregated data
  • Intermediary results
  • Precomputed results
  • Temporary data
Materialized views in query optimization are used to store precomputed results. This involves storing the output of a query in a physical table, which can significantly improve the performance of complex queries by reducing the need for repeated computations.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *