Feb 28, 2023 · Databases

Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide

This article explains how to prepare and tune MySQL SQL statements before execution, covering logical and physical optimization, table and view analysis, join‑key checks, query rewriting, and execution‑plan evaluation to achieve faster, more efficient database queries.

Database PerformanceMySQLQuery Tuning

0 likes · 9 min read

Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide

dbaplus Community

May 22, 2018 · Databases

Understanding PostgreSQL Query Optimizer: Rules, Subqueries, and Cost Models

This article explains PostgreSQL's query optimizer from logical and physical perspectives, covering rule‑based and cost‑based optimization, syntax tree generation, subquery/subjoin lifting, selection push‑down, equivalence‑class reasoning, strictness of expressions, and practical SQL examples.

PostgreSQLQuery Optimizerlogical optimization

0 likes · 30 min read

Understanding PostgreSQL Query Optimizer: Rules, Subqueries, and Cost Models