Author: js221926
Date: 2011-05-17 17:54:08 +0200 (Tue, 17 May 2011)
New Revision: 26252
Log:
Improve ndb_join_pushdown description (Thanks, Jonas!)
Modified:
trunk/refman-5.1/mysql-cluster-configuration-core.xml
Modified: trunk/refman-5.1/mysql-cluster-configuration-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-configuration-core.xml 2011-05-17 13:22:52 UTC (rev 26251)
+++ trunk/refman-5.1/mysql-cluster-configuration-core.xml 2011-05-17 15:54:08 UTC (rev 26252)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 13; 1883 bytes
@@ -10909,27 +10909,26 @@
<listitem>
<para>
- Only fully or partially qualified primary keys or
- indexes are supported for access to child tables.
+ In order for a join to be pushed down, child tables in
+ the join must be accessed using one of the
+ <literal role="jointype">ref</literal>,
+ <literal role="jointype">eq_ref</literal>, or
+ <literal role="jointype">const</literal> access methods,
+ or some combination of these methods. This means that
+ every column referenced in the join must be a primary
+ key or other index, or part of one.
</para>
</listitem>
<listitem>
<para>
- Queries making up the join may use only the
- <literal role="jointype">eq_ref</literal> or
- <literal role="jointype">const</literal> access method
- (or both methods).
+ Joins referencing tables explicitly partitioned by
+ <literal>[LINEAR] HASH</literal>,
+ <literal>LIST</literal>, or <literal>RANGE</literal>
+ currently cannot be pushed down.
</para>
</listitem>
- <listitem>
- <para>
- Joins referencing user-partitioned tables currently
- cannot be pushed down.
- </para>
- </listitem>
-
</itemizedlist>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r26252 - trunk/refman-5.1 | jon.stephens | 17 May |
