How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s

The article walks through diagnosing a slow MySQL 8.0 query that scans 77,724 rows and performs a costly filesort, then rewrites it with a LATERAL join and a new index, reducing execution time to about 0.75 seconds on 30 k rows while explaining the differences between ordinary subqueries and LATERAL, and highlighting the need for deterministic ordering when timestamps duplicate.

LATERALexecution planindex

0 likes · 8 min read

How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s

Aikesheng Open Source Community

Jul 25, 2019 · Databases

Using LATERAL and Recursive CTEs in MySQL to Count Direct and Indirect Employee Reports

This article explains how MySQL's LATERAL join and recursive CTE can be used to compute the number of direct and indirect reports for each employee, demonstrating lateral external references, non‑lateral references, query execution details, and EXPLAIN output in MySQL 8.0.14 and later.

CTEDatabaseLATERAL

0 likes · 8 min read

Using LATERAL and Recursive CTEs in MySQL to Count Direct and Indirect Employee Reports

Big Data Technology & Architecture

Mar 24, 2019 · Databases

Understanding JOIN LATERAL: From Traditional Databases to Apache Flink

This article explains the special JOIN LATERAL operator, compares it with INNER JOIN and correlated subqueries, shows how SQL Server implements it via CROSS APPLY, and demonstrates its support in Apache Flink using Calcite and user‑defined table functions with concrete code examples.

Apache FlinkDatabaseLATERAL

0 likes · 12 min read

Understanding JOIN LATERAL: From Traditional Databases to Apache Flink

How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s

Using LATERAL and Recursive CTEs in MySQL to Count Direct and Indirect Employee Reports

Understanding JOIN LATERAL: From Traditional Databases to Apache Flink

How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s