Author
Siobhán O'Malley
A Senior Writer who dissects the latent logic of predicate pushdown and the complexities of view merging. She is passionate about helping readers visualize the cascading application of rules within execution plans to optimize intermediate result sets.
20 Articles
Articles by
Siobhán O'Malley
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Hidden Math That Makes Your Favorite Apps Fast
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
The Art of the Join: Why Your Data Doesn't Get Tangled
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
The Brain Behind the Screen: How Computers Choose the Best Path for Data
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
The Invisible GPS Inside Your Apps: How Databases Find the Fast Lane
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Why Your App Is Slow and the Math That Fixes It
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
Saving Seconds and Cents: The Secret Math of Fast Websites
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Invisible Budget: How Your Database Picks the Fastest Path
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
The Hidden Brain Inside Your Database: Why Speed Isn't Just Luck
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Brain Inside the Database: How SQL Plans Work
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Why Your Database Acts Like a GPS for Your Data
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Finding the Best Path in a Messy World
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
How Computers Guess Their Way to Speed
Cost-Based Optimization Models
All rights reserved to analyzequery.com
The Secret Brain Inside Your Database
Cost-Based Optimization Models
All rights reserved to analyzequery.com
How Databases Find Your Data Without Breaking a Sweat
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
The Brain Inside Your Database
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
The Invisible Librarian: How Databases Find Your Data Without Breaking a Sweat
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
A Few Lessons on Flow and Finding the Best Path
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
The Invisible Brain Inside Your Database: How Query Optimization Works
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
Why Your App is Slow: The Math of SQL Plans
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
