No Picture

Streaming versus blocking operators in MySQL

In MySQL, operators in a query execution plan can be classified as streaming or blocking based on how they process and propagate rows during query execution. Let’s explore the differences between streaming and blocking operators […]

No Picture

MySQL Scalar Subquery Unnesting transformation

Scalar subquery unnesting is a transformation technique used by the MySQL optimizer to optimize queries that involve scalar subqueries. Scalar subqueries are subqueries that return a single value, typically used in expressions or as part […]