Skip to content
Tagged articles

EXPLAIN Plan

14 articles · Page 1 of 1
Java Tech Workshop
Java Tech Workshop
Oct 27, 2026 · Databases

MySQL Index Failure Causes: EXPLAIN Analysis & Real-World Fixes

This article explains common MySQL index invalidation causes—implicit type conversion, functions on indexed columns, composite index ordering, and optimizer cost decisions—using EXPLAIN output analysis, and demonstrates a full slow query troubleshooting process from log to fix.

Composite IndexDatabase PerformanceEXPLAIN Plan
0 likes · 23 min read
MySQL Index Failure Causes: EXPLAIN Analysis & Real-World Fixes
Ray's Galactic Tech
Ray's Galactic Tech
Oct 13, 2026 · Backend Development

Production-Ready Text-to-SQL: Secure Governance from Restricted Semantics to Revocable Execution

This article details a comprehensive governance framework for deploying Text-to-SQL systems in production, covering threat modeling, AST validation, multi-tenant isolation, performance admission via EXPLAIN, database permission hardening, budget-aware execution, cancellation semantics, and phased rollout strategies to ensure secure, auditable, and revocable data access.

AST ValidationEXPLAIN PlanJSqlParser
0 likes · 39 min read
Production-Ready Text-to-SQL: Secure Governance from Restricted Semantics to Revocable Execution
Su San Talks Tech
Su San Talks Tech
Mar 16, 2024 · Databases

Master MySQL Performance: Deep Dive into Indexes and Explain Plans

This comprehensive guide explains MySQL's architecture, the importance of SQL optimization, detailed index types and creation methods, how to interpret EXPLAIN output, and practical techniques to improve query performance while avoiding common pitfalls.

EXPLAIN PlanMySQLPerformance Tuning
0 likes · 35 min read
Master MySQL Performance: Deep Dive into Indexes and Explain Plans
Java High-Performance Architecture
Java High-Performance Architecture
Nov 13, 2023 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization

This comprehensive guide explores MySQL’s architecture, explains how queries are parsed and executed, and provides detailed techniques for optimizing SQL performance through effective indexing, understanding EXPLAIN output, and avoiding common pitfalls that cause index misuse and slow query execution.

Database PerformanceEXPLAIN PlanIndexing
0 likes · 37 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Nov 3, 2023 · Databases

Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis

This article provides an in‑depth overview of MySQL’s core architecture, storage engines, index types, and practical SQL optimization methods, followed by detailed explanations of the EXPLAIN plan keywords and numerous real‑world examples to help developers improve query performance and avoid common indexing pitfalls.

Database PerformanceEXPLAIN PlanSQL Optimization
0 likes · 34 min read
Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis
ITPUB
ITPUB
Aug 15, 2023 · Databases

Master MySQL Performance: Practical SQL Optimization and Indexing Techniques

This comprehensive guide explains MySQL’s architecture, index fundamentals, the EXPLAIN plan keywords, step‑by‑step index creation and deletion commands, and numerous real‑world optimization examples, helping developers dramatically improve query execution speed while avoiding common pitfalls.

Database PerformanceEXPLAIN PlanMySQL
0 likes · 35 min read
Master MySQL Performance: Practical SQL Optimization and Indexing Techniques
Open Source Linux
Open Source Linux
Feb 9, 2023 · Databases

Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips

This comprehensive guide explores MySQL architecture, index types, query execution plans, and practical optimization techniques, offering detailed examples of creating, modifying, and analyzing indexes, avoiding common pitfalls, and improving query performance through proper use of EXPLAIN, composite indexes, and query rewriting.

EXPLAIN PlanMySQLSQL Optimization
0 likes · 36 min read
Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips
dbaplus Community
dbaplus Community
Aug 21, 2022 · Databases

Master MySQL Performance: Architecture, Indexes, and Advanced Query Tuning

This comprehensive guide walks you through MySQL's core architecture, explains why SQL optimization matters, details index types and creation methods, demystifies EXPLAIN output, and provides practical examples and best‑practice tips to dramatically improve query performance.

Database PerformanceEXPLAIN PlanIndexing
0 likes · 34 min read
Master MySQL Performance: Architecture, Indexes, and Advanced Query Tuning
Laravel Tech Community
Laravel Tech Community
Mar 31, 2022 · Databases

SQL Optimization Steps and Common Cases for Improving Query Performance

This article outlines a systematic approach to identifying and fixing slow MySQL queries, explains how to interpret EXPLAIN output and profiling information, and presents multiple real‑world cases illustrating index usage, implicit conversion, large pagination, IN queries, and other optimization techniques.

EXPLAIN PlanIndexingMySQL
0 likes · 10 min read
SQL Optimization Steps and Common Cases for Improving Query Performance
Java Backend Technology
Java Backend Technology
Mar 23, 2022 · Databases

Master MySQL Performance: 10 Proven SQL Optimization Techniques

This article walks through why SQL queries become bottlenecks as data grows and presents a step‑by‑step guide—including slow‑query analysis, EXPLAIN interpretation, profiling, optimizer tracing, index tuning, and scenario‑specific tricks—to dramatically improve MySQL performance.

EXPLAIN PlanMySQLSQL Optimization
0 likes · 12 min read
Master MySQL Performance: 10 Proven SQL Optimization Techniques
Youzan Coder
Youzan Coder
Feb 17, 2022 · Databases

Master MySQL Slow Query Optimization: Practical Indexing Techniques

This article shares hands‑on experience with MySQL 5.7 slow‑query problems, explaining common causes, proper index design, pitfalls that invalidate indexes, efficient SQL writing, deep‑pagination avoidance, and how to use EXPLAIN to verify that queries leverage the right indexes.

Database PerformanceEXPLAIN PlanIndex Optimization
0 likes · 16 min read
Master MySQL Slow Query Optimization: Practical Indexing Techniques
Code Ape Tech Column
Code Ape Tech Column
Jan 20, 2021 · Databases

Why Does MySQL Pick the Wrong Index? A Deep Dive into Query Optimization

This article examines a slow MySQL query that scans millions of rows, explains why the optimizer chose a low‑selectivity index, demonstrates how forcing the correct index dramatically improves performance, and shows how to create a covering composite index to resolve the issue permanently.

Covering IndexEXPLAIN PlanIndex Optimization
0 likes · 8 min read
Why Does MySQL Pick the Wrong Index? A Deep Dive into Query Optimization