Which database system feature can help improve query performance by storing precomputed results?

  • Cursors
  • Materialized Views
  • Stored Procedures
  • Triggers
Materialized Views are database objects that store the results of a query as a physical table. They contain precomputed results based on the underlying query, which can help improve query performance by reducing the need to recompute the results every time the query is executed. Materialized Views are especially useful for queries that involve complex calculations or aggregations, as they allow the system to retrieve the results directly from the stored data without having to recompute them from scratch.
Add your answer
Loading...

Leave a comment

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