Next-Generation Query Optimization: A Systematic Review of Cost Models, Equivalence Rules, and Materialized Views
The evidence indicates that adaptive cost models achieve 15–30% efficiency gains over classical models but at higher computational cost, graphbased equivalence transformations reduce query latency by around 18% compared to static rules, and materialized views deliver 15–32% performance gains but introduce 10–20% storag...