Author: paul
Date: 2007-01-10 19:24:53 +0100 (Wed, 10 Jan 2007)
New Revision: 4440
Log:
r17914@polar: paul | 2007-01-10 12:22:24 -0600
Additional Extra values for EXPLAIN. (Bug#23725)
Modified:
trunk/refman-4.1/optimization.xml
trunk/refman-5.0/optimization.xml
trunk/refman-5.1/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:17912
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14371
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:17914
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14371
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015
Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml 2007-01-10 18:10:57 UTC (rev 4439)
+++ trunk/refman-4.1/optimization.xml 2007-01-10 18:24:53 UTC (rev 4440)
Changed blocks: 2, Lines Added: 40, Lines Deleted: 0; 1891 bytes
@@ -1336,6 +1336,30 @@
<listitem>
<para>
+ <literal>Impossible WHERE noticed after reading const
+ tables</literal>
+ </para>
+
+ <para>
+ MySQL has read all <literal>const</literal> (and
+ <literal>system</literal>) tables and notice that the
+ <literal>WHERE</literal> clause is always false.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>No tables</literal>
+ </para>
+
+ <para>
+ The query has no <literal>FROM</literal> clause, or has
+ a <literal>FROM DUAL</literal> clause.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Not exists</literal>
</para>
@@ -1397,6 +1421,22 @@
<listitem>
<para>
+ <literal>Select tables optimized away</literal>
+ </para>
+
+ <para>
+ The query contained only aggregate functions
+ (<literal>MIN()</literal>, <literal>MAX()</literal>)
+ that were all resolved using an index, or
+ <literal>COUNT(*)</literal> for
+ <literal>MyISAM</literal>, and no <literal>GROUP
+ BY</literal> clause. The optimizer determined that only
+ one row should be returned.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Using filesort</literal>
</para>
Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml 2007-01-10 18:10:57 UTC (rev 4439)
+++ trunk/refman-5.0/optimization.xml 2007-01-10 18:24:53 UTC (rev 4440)
Changed blocks: 2, Lines Added: 40, Lines Deleted: 0; 1891 bytes
@@ -1345,6 +1345,30 @@
<listitem>
<para>
+ <literal>Impossible WHERE noticed after reading const
+ tables</literal>
+ </para>
+
+ <para>
+ MySQL has read all <literal>const</literal> (and
+ <literal>system</literal>) tables and notice that the
+ <literal>WHERE</literal> clause is always false.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>No tables</literal>
+ </para>
+
+ <para>
+ The query has no <literal>FROM</literal> clause, or has
+ a <literal>FROM DUAL</literal> clause.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Not exists</literal>
</para>
@@ -1405,6 +1429,22 @@
<listitem>
<para>
+ <literal>Select tables optimized away</literal>
+ </para>
+
+ <para>
+ The query contained only aggregate functions
+ (<literal>MIN()</literal>, <literal>MAX()</literal>)
+ that were all resolved using an index, or
+ <literal>COUNT(*)</literal> for
+ <literal>MyISAM</literal>, and no <literal>GROUP
+ BY</literal> clause. The optimizer determined that only
+ one row should be returned.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Using filesort</literal>
</para>
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2007-01-10 18:10:57 UTC (rev 4439)
+++ trunk/refman-5.1/optimization.xml 2007-01-10 18:24:53 UTC (rev 4440)
Changed blocks: 2, Lines Added: 40, Lines Deleted: 0; 1891 bytes
@@ -1402,6 +1402,30 @@
<listitem>
<para>
+ <literal>Impossible WHERE noticed after reading const
+ tables</literal>
+ </para>
+
+ <para>
+ MySQL has read all <literal>const</literal> (and
+ <literal>system</literal>) tables and notice that the
+ <literal>WHERE</literal> clause is always false.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>No tables</literal>
+ </para>
+
+ <para>
+ The query has no <literal>FROM</literal> clause, or has
+ a <literal>FROM DUAL</literal> clause.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Not exists</literal>
</para>
@@ -1462,6 +1486,22 @@
<listitem>
<para>
+ <literal>Select tables optimized away</literal>
+ </para>
+
+ <para>
+ The query contained only aggregate functions
+ (<literal>MIN()</literal>, <literal>MAX()</literal>)
+ that were all resolved using an index, or
+ <literal>COUNT(*)</literal> for
+ <literal>MyISAM</literal>, and no <literal>GROUP
+ BY</literal> clause. The optimizer determined that only
+ one row should be returned.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>Using filesort</literal>
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r4440 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 10 Jan |
