Author
Mara Vance
Mara is a Senior Writer specializing in the physical layer of query execution, specifically indexing structures and join ordering dependencies. She frequently explores the trade-offs between B-trees and hash indexes when dealing with skewed data distributions.
9 Articles
Articles by
Mara Vance
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
Autonomous SQL Tuning: The Shift Toward Machine-Managed Relational Query Optimization
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Transition from Heuristic to Learned Models in Relational Query Optimization Mechanics
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Evolution of Execution Plan Visualization: A History of Database Tooling
Cost-Based Optimization Models
All rights reserved to analyzequery.com
The Selinger Legacy: How the 1979 System R Paper Defined Modern SQL
Cost-Based Optimization Models
All rights reserved to analyzequery.com
From Rules to Costs: Oracle's Decade-Long Migration to the Cost-Based Optimizer
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
The Predicate Pushdown Debate: Historical Performance Gains in Distributed SQL
Cost-Based Optimization Models
All rights reserved to analyzequery.com
From Volcano to Cascades: A Timeline of Extensible Optimizer Frameworks
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Comparative Benchmarks of Join Algorithms: Hash vs. Merge vs. Nested Loop
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com