Analyzequery
Home Author Mara Vance
Mara Vance
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
Autonomous SQL Tuning: The Shift Toward Machine-Managed Relational Query Optimization Statistics and Cardinality Estimation All rights reserved to analyzequery.com

Autonomous SQL Tuning: The Shift Toward Machine-Managed Relational Query Optimization

Mara Vance - Apr 20, 2026
The Transition from Heuristic to Learned Models in Relational Query Optimization Mechanics Statistics and Cardinality Estimation All rights reserved to analyzequery.com

The Transition from Heuristic to Learned Models in Relational Query Optimization Mechanics

Mara Vance - Apr 17, 2026
Evolution of Execution Plan Visualization: A History of Database Tooling Execution Plan Analysis and Visualization All rights reserved to analyzequery.com

Evolution of Execution Plan Visualization: A History of Database Tooling

Mara Vance - Mar 16, 2026
The Selinger Legacy: How the 1979 System R Paper Defined Modern SQL Cost-Based Optimization Models All rights reserved to analyzequery.com

The Selinger Legacy: How the 1979 System R Paper Defined Modern SQL

Mara Vance - Feb 25, 2026
From Rules to Costs: Oracle's Decade-Long Migration to the Cost-Based Optimizer Cost-Based Optimization Models All rights reserved to analyzequery.com

From Rules to Costs: Oracle's Decade-Long Migration to the Cost-Based Optimizer

Mara Vance - Jan 5, 2026
The Predicate Pushdown Debate: Historical Performance Gains in Distributed SQL Execution Plan Analysis and Visualization All rights reserved to analyzequery.com

The Predicate Pushdown Debate: Historical Performance Gains in Distributed SQL

Mara Vance - Dec 25, 2025
From Volcano to Cascades: A Timeline of Extensible Optimizer Frameworks Cost-Based Optimization Models All rights reserved to analyzequery.com

From Volcano to Cascades: A Timeline of Extensible Optimizer Frameworks

Mara Vance - Dec 13, 2025
Comparative Benchmarks of Join Algorithms: Hash vs. Merge vs. Nested Loop Execution Plan Analysis and Visualization All rights reserved to analyzequery.com

Comparative Benchmarks of Join Algorithms: Hash vs. Merge vs. Nested Loop

Mara Vance - Nov 10, 2025
Volcano and Cascades: Frameworks for Algebraic Query Transformation Algebraic Transformations and Query Rewriting All rights reserved to analyzequery.com

Volcano and Cascades: Frameworks for Algebraic Query Transformation

Mara Vance - Nov 2, 2025
Analyzequery