BestHub
Sign in
Tagged articles
14 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Feb 23, 2026 · Databases

How to Diagnose and Optimize a Minute‑Long MySQL Join Query

This article walks through a real‑world MySQL slow‑query case, explains the inner workings of Join and Order by algorithms, shows how to interpret EXPLAIN and Optimizer_trace output, and demonstrates how adding an index can transform a costly Block Nested‑Loop Join into a fast Index Nested‑Loop Join, dramatically improving performance.

Join AlgorithmsOptimizer_traceOrder By
0 likes · 13 min read
How to Diagnose and Optimize a Minute‑Long MySQL Join Query
JD Tech
JD Tech
Dec 13, 2024 · Databases

MySQL Join Algorithms and Optimization Techniques

This article explains how multi‑table joins in MySQL can become performance bottlenecks and walks through the four join algorithms—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop—showing their execution plans, code examples, and step‑by‑step optimizations using indexes and join buffers to dramatically improve query speed.

Join AlgorithmsSQL Optimizationdatabase
0 likes · 19 min read
MySQL Join Algorithms and Optimization Techniques
JD Tech Talk
JD Tech Talk
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explores MySQL's join processing methods—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop joins—demonstrates how to create test tables, analyze execution plans, and apply practical optimizations such as indexing and query rewriting to dramatically improve multi‑table query performance.

Database PerformanceJoin AlgorithmsSQL Optimization
0 likes · 21 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
JD Cloud Developers
JD Cloud Developers
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explains how MySQL processes multi‑table joins, compares Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop join algorithms, and demonstrates practical optimization techniques using indexes, join buffers, and query rewrites to dramatically improve performance on large datasets.

Database PerformanceJoin AlgorithmsSQL Optimization
0 likes · 20 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
Senior Tony
Senior Tony
Jul 10, 2024 · Databases

When to Use MySQL Hash Join vs. Nested Loop: A Practical Guide

This article explains MySQL's hash join algorithm, compares it with nested‑loop joins, shows how to read execution steps and EXPLAIN output, discusses extended hash‑join scenarios, and weighs the trade‑offs of performing multi‑table joins inside the database versus in application code.

Database OptimizationHash JoinJoin Algorithms
0 likes · 8 min read
When to Use MySQL Hash Join vs. Nested Loop: A Practical Guide
Senior Tony
Senior Tony
Jul 4, 2024 · Databases

Why MySQL Joins Aren’t Always Slow: Inside the Four Join Algorithms

This article uses a realistic interview scenario to explore why multi-table joins in MySQL are not inherently slow, detailing four join algorithms—simple nested-loop, index nested-loop, block nested-loop, and batched key access—along with their pseudo‑code, execution steps, performance trade‑offs, and the impact of features like MRR and recent optimizer changes.

Index JoinJoin AlgorithmsNested Loop
0 likes · 10 min read
Why MySQL Joins Aren’t Always Slow: Inside the Four Join Algorithms
vivo Internet Technology
vivo Internet Technology
Apr 13, 2022 · Big Data

Understanding Join Algorithms in Presto: Theory, Implementation, and Engineering Practices

The article explains Presto’s join processing by detailing the business need to limit multi‑table joins, then describing nested‑loop, sort‑merge, and hash join algorithms with Java examples, and finally showing how the Volcano model, columnar pages, and planner integration enable scalable, efficient OLAP join execution.

Big DataHash JoinJoin Algorithms
0 likes · 17 min read
Understanding Join Algorithms in Presto: Theory, Implementation, and Engineering Practices
Java High-Performance Architecture
Java High-Performance Architecture
Nov 28, 2019 · Databases

How MySQL 8’s Hash Join Boosts Query Performance

Learn how MySQL 8’s hash join algorithm works by building an in‑memory hash table from the smaller table, probing the larger table for matches, and handling oversized tables through disk‑based chunk files, offering a more efficient alternative to traditional nested‑loop joins.

Hash JoinJoin AlgorithmsSQL
0 likes · 5 min read
How MySQL 8’s Hash Join Boosts Query Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 19, 2019 · Databases

Understanding Hash Join in MySQL 8.0.18

This article explains how MySQL 8.0.18 introduces the hash join algorithm, describes its build and probe phases, disk‑overflow handling, usage instructions, optimizer switches, performance comparisons with block nested loops, and current limitations, providing code examples and practical guidance.

Hash JoinJoin AlgorithmsSQL
0 likes · 9 min read
Understanding Hash Join in MySQL 8.0.18
Meituan Technology Team
Meituan Technology Team
Nov 2, 2017 · Big Data

Dashiang Cube: A Multi‑Source BI Reporting Tool with Custom Join Algorithms

Meituan‑Dianping’s Dashiang Cube is a multi‑source BI reporting platform that unifies MySQL, Kylin, Elasticsearch and plain‑text data via a common SQL layer, generates dialect‑specific queries, performs custom back‑tracking inner and left outer joins across heterogeneous sources, supports scripted metric calculations, permission controls, and a reusable UI component library for self‑service reporting.

BIData PermissionsData Warehouse
0 likes · 14 min read
Dashiang Cube: A Multi‑Source BI Reporting Tool with Custom Join Algorithms