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.
Sign in to unlock the rest of this answer
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