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
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
The Invisible Traffic Controller in Your Favorite App
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
Solving the SQL Puzzle: Why Some Queries Fly and Others Crawl
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
Why Databases Need a GPS to Find Your Data
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
Why SQL Engines are Like Master Chefs
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Guessing Game: How Databases Predict the Future
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
Why Databases Are the Fastest Accountants You'll Never Meet
Join Ordering and Execution Algorithms
All rights reserved to analyzequery.com
Distributed Database Architectures Force Re-Evaluation of Join Ordering and Predicate Pushdown Mechanics
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
Machine Learning Integration Redefines SQL Execution Plan Accuracy
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Sustainability Initiatives Target SQL Efficiency to Reduce Data Center Carbon Footprints
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Evolution of Cost-Based Optimization in Distributed Relational Engines
Statistics and Cardinality Estimation
All rights reserved to analyzequery.com
The Evolution of Cost-Based Optimization in Distributed Relational Databases
Indexing Strategies and Physical Access Paths
All rights reserved to analyzequery.com
The Evolution of Distributed Query Optimization in Cloud-Native Relational Databases
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Optimizing Distributed SQL: The Challenge of Query Mechanics in Cloud-Native Environments
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Transition from Rule-Based to Cost-Based Optimization: Oracle Case Study
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
Evolution of Predicate Pushdown: From Algebraic Rules to Distributed Execution
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Heuristics vs. Genetics: The Join Order Problem in PostgreSQL GEQO
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
