What is a materialized view?
1Times asked
Aug 2026Last seen
Aug 2026First seen
💡 Model Answer
A materialized view is a database object that stores the result of a query physically on disk. Unlike a regular view, which is just a stored query definition, a materialized view can be refreshed periodically or on demand. It improves query performance for complex aggregations or joins because the data is precomputed. Materialized views can have indexes to further speed up access, and they require maintenance to keep the data up to date.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500