Cost-Based Optimizer

Aikesheng Open Source Community

Sep 26, 2021 · Databases

Why MySQL Optimizer Chooses Full Table Scan Over Index Scan: Cost Analysis and Experiment

This article explains how MySQL's cost‑based optimizer decides between using an index and performing a full table scan, demonstrates the behavior with a large test table, shows optimizer trace details, and clarifies why index access can sometimes be more expensive than scanning the whole table.

Cost-Based OptimizerDatabase PerformanceFull Table Scan

0 likes · 8 min read

Why MySQL Optimizer Chooses Full Table Scan Over Index Scan: Cost Analysis and Experiment

Aikesheng Open Source Community

Sep 3, 2019 · Databases

Cost‑Based MySQL Query Optimization: Concepts, Tools, and Practical Tips

This article summarizes a MySQL webinar covering cost‑based query optimization, monitoring and analysis tools, data‑access methods and index selection, join optimization techniques, and ways to influence the optimizer through hints and configuration, providing a concise technical reference for database practitioners.

Cost-Based OptimizerIndex SelectionJoin Optimization

0 likes · 11 min read

Cost‑Based MySQL Query Optimization: Concepts, Tools, and Practical Tips

360 Tech Engineering

Jan 7, 2019 · Databases

SQL Query Analysis and Access Path Strategies

This article explains how relational optimizers validate, analyze, and transform SQL statements into executable code, detailing the four-step optimization process, query‑analysis factors, cost‑based access‑path selection, table scans, index lookups, and the role of data prefetching in improving performance.

Access PathCost-Based OptimizerDatabase Performance

0 likes · 12 min read

SQL Query Analysis and Access Path Strategies