At what point is a non-materialized view evaluated during query execution?
1Times asked
Jul 2026Last seen
Jul 2026First seen
💡 Model Answer
A non-materialized view is evaluated at query time. The database expands the view’s definition into the SELECT statement and runs the combined query when the statement is executed. This happens after the optimizer has processed the query, so the view always reflects the latest data in its base tables. Because the view is not precomputed, each reference incurs the cost of re‑executing its underlying logic.
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