svn commit - mysqldoc@docsrva: r9977 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0

[paul]

Author: paul
Date: 2008-02-22 16:27:18 +0100 (Fri, 22 Feb 2008)
New Revision: 9977

Log:
 r29435@frost:  paul | 2008-02-22 09:24:56 -0600
 - Information on interpreting N in
   "Range checked for each record (index map: N)"
 - Updated out-of-date examples
 (Bug#30757)


Modified:
   trunk/refman-4.1/optimization.xml
   trunk/refman-5.0/optimization.xml
   trunk/refman-5.1/optimization.xml
   trunk/refman-6.0/optimization.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29427
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29561
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29435
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29561


Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml	2008-02-22 11:12:59 UTC (rev 9976)
+++ trunk/refman-4.1/optimization.xml	2008-02-22 15:27:18 UTC (rev 9977)
Changed blocks: 4, Lines Added: 14, Lines Deleted: 4; 1992 bytes

@@ -1398,7 +1398,7 @@
 
             <listitem>
               <para>
-                <literal>range checked for each record (index map:
+                <literal>Range checked for each record (index map:
                 <replaceable>N</replaceable>)</literal>
               </para>
 

@@ -1418,6 +1418,16 @@
                 This is not very fast, but is faster than performing a
                 join with no index at all.
               </para>
+
+              <para>
+                Indexes are numbered beginning with 1, in the same order
+                as shown by <literal>SHOW INDEX</literal> for the table.
+                The index map value <replaceable>N</replaceable> is a
+                bitmask value that indicates which indexes are
+                candidates. For example, a value of
+                <literal>0x19</literal> (binary 11001) means that
+                indexes 1, 4, and 5 will be considered.
+              </para>
             </listitem>
 
             <listitem>

@@ -1675,7 +1685,7 @@
 tt    ALL  AssignedPC,   NULL NULL    NULL 3872
            ClientID,
            ActualPC
-      range checked for each record (key map: 35)
+      Range checked for each record (index map: 0x23)
 </programlisting>
 
       <para>

@@ -1724,9 +1734,9 @@
              ClientID,                                         where
              ActualPC
 do    ALL    PRIMARY       NULL    NULL    NULL        2135
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et_1  ALL    PRIMARY       NULL    NULL    NULL        74
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et    eq_ref PRIMARY       PRIMARY 15      tt.ActualPC 1
 </programlisting>
 


Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml	2008-02-22 11:12:59 UTC (rev 9976)
+++ trunk/refman-5.0/optimization.xml	2008-02-22 15:27:18 UTC (rev 9977)
Changed blocks: 4, Lines Added: 14, Lines Deleted: 4; 2009 bytes

@@ -1419,7 +1419,7 @@
 
             <listitem>
               <para>
-                <literal>range checked for each record (index map:
+                <literal>Range checked for each record (index map:
                 <replaceable>N</replaceable>)</literal>
               </para>
 

@@ -1438,6 +1438,16 @@
                 exception that all column values for the preceding table
                 are known and considered to be constants.
               </para>
+
+              <para>
+                Indexes are numbered beginning with 1, in the same order
+                as shown by <literal>SHOW INDEX</literal> for the table.
+                The index map value <replaceable>N</replaceable> is a
+                bitmask value that indicates which indexes are
+                candidates. For example, a value of
+                <literal>0x19</literal> (binary 11001) means that
+                indexes 1, 4, and 5 will be considered.
+              </para>
             </listitem>
 
             <listitem>

@@ -1955,7 +1965,7 @@
 tt    ALL  AssignedPC,   NULL NULL    NULL 3872
            ClientID,
            ActualPC
-      range checked for each record (key map: 35)
+      Range checked for each record (index map: 0x23)
 </programlisting>
 
       <para>

@@ -2003,9 +2013,9 @@
              ClientID,                                         where
              ActualPC
 do    ALL    PRIMARY       NULL    NULL    NULL        2135
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et_1  ALL    PRIMARY       NULL    NULL    NULL        74
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et    eq_ref PRIMARY       PRIMARY 15      tt.ActualPC 1
 </programlisting>
 


Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml	2008-02-22 11:12:59 UTC (rev 9976)
+++ trunk/refman-5.1/optimization.xml	2008-02-22 15:27:18 UTC (rev 9977)
Changed blocks: 4, Lines Added: 14, Lines Deleted: 4; 2009 bytes

@@ -1483,7 +1483,7 @@
 
             <listitem>
               <para>
-                <literal>range checked for each record (index map:
+                <literal>Range checked for each record (index map:
                 <replaceable>N</replaceable>)</literal>
               </para>
 

@@ -1502,6 +1502,16 @@
                 exception that all column values for the preceding table
                 are known and considered to be constants.
               </para>
+
+              <para>
+                Indexes are numbered beginning with 1, in the same order
+                as shown by <literal>SHOW INDEX</literal> for the table.
+                The index map value <replaceable>N</replaceable> is a
+                bitmask value that indicates which indexes are
+                candidates. For example, a value of
+                <literal>0x19</literal> (binary 11001) means that
+                indexes 1, 4, and 5 will be considered.
+              </para>
             </listitem>
 
             <listitem>

@@ -2105,7 +2115,7 @@
 tt    ALL  AssignedPC,   NULL NULL    NULL 3872
            ClientID,
            ActualPC
-      range checked for each record (key map: 35)
+      Range checked for each record (index map: 0x23)
 </programlisting>
 
       <para>

@@ -2153,9 +2163,9 @@
              ClientID,                                         where
              ActualPC
 do    ALL    PRIMARY       NULL    NULL    NULL        2135
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et_1  ALL    PRIMARY       NULL    NULL    NULL        74
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et    eq_ref PRIMARY       PRIMARY 15      tt.ActualPC 1
 </programlisting>
 


Modified: trunk/refman-6.0/optimization.xml
===================================================================
--- trunk/refman-6.0/optimization.xml	2008-02-22 11:12:59 UTC (rev 9976)
+++ trunk/refman-6.0/optimization.xml	2008-02-22 15:27:18 UTC (rev 9977)
Changed blocks: 4, Lines Added: 14, Lines Deleted: 4; 2009 bytes

@@ -1481,7 +1481,7 @@
 
             <listitem>
               <para>
-                <literal>range checked for each record (index map:
+                <literal>Range checked for each record (index map:
                 <replaceable>N</replaceable>)</literal>
               </para>
 

@@ -1500,6 +1500,16 @@
                 exception that all column values for the preceding table
                 are known and considered to be constants.
               </para>
+
+              <para>
+                Indexes are numbered beginning with 1, in the same order
+                as shown by <literal>SHOW INDEX</literal> for the table.
+                The index map value <replaceable>N</replaceable> is a
+                bitmask value that indicates which indexes are
+                candidates. For example, a value of
+                <literal>0x19</literal> (binary 11001) means that
+                indexes 1, 4, and 5 will be considered.
+              </para>
             </listitem>
 
             <listitem>

@@ -2101,7 +2111,7 @@
 tt    ALL  AssignedPC,   NULL NULL    NULL 3872
            ClientID,
            ActualPC
-      range checked for each record (key map: 35)
+      Range checked for each record (index map: 0x23)
 </programlisting>
 
       <para>

@@ -2149,9 +2159,9 @@
              ClientID,                                         where
              ActualPC
 do    ALL    PRIMARY       NULL    NULL    NULL        2135
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et_1  ALL    PRIMARY       NULL    NULL    NULL        74
-      range checked for each record (key map: 1)
+      Range checked for each record (index map: 0x1)
 et    eq_ref PRIMARY       PRIMARY 15      tt.ActualPC 1
 </programlisting>