List:Commits« Previous MessageNext Message »
From:paul.dubois Date:December 21 2010 3:40pm
Subject: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
View as plain text  
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.0paul.dubois21 Dec