Related Documentation Download this Manual
PDF (US Ltr) - 37.7Mb
PDF (A4) - 37.7Mb
PDF (RPM) - 33.8Mb
HTML Download (TGZ) - 8.3Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.3Mb
Man Pages (TGZ) - 130.0Kb
Man Pages (Zip) - 185.6Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb


MySQL 8.0 Reference Manual  /  ...  /  Limits on Joins

Pre-General Availability Draft: 2018-02-22

C.10.1 Limits on Joins

The maximum number of tables that can be referenced in a single join is 61. This includes a join handled by merging derived tables (subqueries) and views in the FROM clause into the outer query block (see Section 8.2.2.3, “Optimizing Derived Tables, View References, and Common Table Expressions”). It also applies to the number of tables that can be referenced in the definition of a view.


User Comments
Sign Up Login You must be logged in to post a comment.