Subquery optimizations map

You are viewing an old version of this article. View the current version here.

Below is a map of subqueries.

  • The map shows all kinds of subqueries allowed in SQL language. It shows
    • Subqueries that have form x IN (SELECT ...)
    • Subqueries that are in the FROM clause
    • .. and so forth
  • The size of the areas roughly corresponds to how important (i.e. frequently used) a particular kind of subquery is. For example, x IN (SELECT ...) are the most important.
  • Colored areas represent optimizations/execution strategies that are applied for particular kinds of subqueries.
  • The color of the area shows which version the optimization was added in. See the legend below the diagram to tell which color means which version.

Attachment 'subquery-optimizations-map1' not found

Links to pages about individual optimizations:

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.