Tagged articles

Optimizer Hints

4 articles · Page 1 of 1

Feb 14, 2026 · Databases

Deep Dive into MySQL Query Optimizer: From Writing SQL to Controlling Performance

This article explains MySQL’s query execution pipeline—from parsing to the storage engine—details the cost‑based optimizer’s model, shows how it evaluates index choices versus full‑table scans, demonstrates using optimizer hints and FORCE INDEX, and provides monitoring commands and best‑practice recommendations for effective query tuning.

Cost-Based OptimizationIndex SelectionOptimizer Hints

0 likes · 9 min read

Deep Dive into MySQL Query Optimizer: From Writing SQL to Controlling Performance

Senior Brother's Insights

Oct 10, 2025 · Databases

Why Implicit Type Conversion Breaks Indexes in MySQL Joins and How to Fix It

This article explains how MySQL's implicit type conversion during table joins can render indexes unusable or alter join order, and provides practical solutions such as aligning column types, using optimizer hints, and forcing indexes to restore query performance.

Optimizer Hintsforce indeximplicit conversion

0 likes · 6 min read

Why Implicit Type Conversion Breaks Indexes in MySQL Joins and How to Fix It

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.

Index SelectionOptimizer HintsPerformance Schema

0 likes · 11 min read

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

dbaplus Community

Jun 15, 2017 · Databases

Why a Single Filter Turned a 2‑second Oracle Query into 90 Seconds—and How to Fix It

A developer added a seemingly harmless filter to an Oracle SQL statement, causing the optimizer to switch the driving table and join method, which inflated execution time from 2 seconds to 90 seconds, prompting a deep dive into execution plans, indexing, and hint techniques.

Execution PlanIndexingOptimizer Hints

0 likes · 12 min read

Why a Single Filter Turned a 2‑second Oracle Query into 90 Seconds—and How to Fix It