Author: paul
Date: 2010-12-21 16:40:27 +0100 (Tue, 21 Dec 2010)
New Revision: 24517
Log:
r43347@dhcp-adc-twvpn-1-vpnpool-10-154-17-115: paul | 2010-12-21 08:41:09 -0500
Update to 'Using where' explanation (James)
Modified:
trunk/refman-4.1/optimization.xml
trunk/refman-5.0/optimization.xml
trunk/refman-5.1/optimization.xml
trunk/refman-5.5/optimization.xml
trunk/refman-5.6/optimization.xml
trunk/refman-6.0/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:45616
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:66486
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:43342
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:45616
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:66486
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:43347
Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-4.1/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -1557,7 +1557,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-5.0/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -1601,7 +1601,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-5.1/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -1761,7 +1761,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
Modified: trunk/refman-5.5/optimization.xml
===================================================================
--- trunk/refman-5.5/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-5.5/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -6778,7 +6778,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
Modified: trunk/refman-5.6/optimization.xml
===================================================================
--- trunk/refman-5.6/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-5.6/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -9255,7 +9255,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
Modified: trunk/refman-6.0/optimization.xml
===================================================================
--- trunk/refman-6.0/optimization.xml 2010-12-21 15:40:14 UTC (rev 24516)
+++ trunk/refman-6.0/optimization.xml 2010-12-21 15:40:27 UTC (rev 24517)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 842 bytes
@@ -1832,7 +1832,11 @@
value is not <literal>Using where</literal> and the
table join type is
<literal role="jointype_all">ALL</literal> or
- <literal role="jointype">index</literal>.
+ <literal role="jointype">index</literal>. Even if you
+ are using an index for all parts of a
+ <literal>WHERE</literal> clause, you may see
+ <literal>Using where</literal> if the column can be
+ <literal>NULL</literal>.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r24517 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0 | paul.dubois | 21 Dec |
