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.
20 Articles
Articles by
Mara Vance
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
Finding the Best Path When the View is Hazy
Small Signals and the Best Paths
Finding the Signal in the Mess: This Week's Lessons
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Smart Ways to Find the Best Path for Your Data
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Smart Paths and Hidden Clues
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Secret Logic of Joining Data Tables
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Why Your Server is Sweating: The Struggle for Efficient SQL
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
Saving Millions One SQL Statement at a Time
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
Why Your Favorite Apps Are Getting Snappier
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Why Your Database Needs a Smart GPS
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
The Hidden GPS Inside Your Database: How Computers Find Information Fast
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
Sorting the Haystack: How Databases Find Your Data Without Searching Everything
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
The Secret Math Saving Your Cloud Budget
Cost-Based Optimization Models
All rights reserved to analyzequery.com
The Art of the Big Data Puzzle
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Art of the Join: Why Your Database Loves Shortcuts
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Invisible Navigator: How Databases Find the Fastest Route to Your Data
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Invisible Traffic Controller Inside Your Database
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
Why Your SQL Queries Might Be Running Slow
Cost-Based Optimization Models
All rights reserved to analyzequery.com