Mention how using materialized views optimized a job by 70%.
💡 Model Answer
In a reporting pipeline, we had a query that joined three large fact tables and aggregated sales by region. The query took 30 seconds on a production cluster. We created a materialized view that pre‑joined the three tables and pre‑aggregated the sales per region. After refreshing the view nightly, the same query now reads from the materialized view and runs in 4 seconds, a 70% reduction in runtime. The materialized view also reduced CPU usage on the cluster, freeing resources for other workloads.
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 — invisible to screen sharing.
Get Assisting AI — Starts at ₹500