db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1412279 - in /db/derby/docs/branches/10.9/src: ref/rrefsqlj41207.dita tuning/ctundepth1002853.dita
Date Wed, 21 Nov 2012 20:40:08 GMT
Author: chaase3
Date: Wed Nov 21 20:40:08 2012
New Revision: 1412279

URL: http://svn.apache.org/viewvc?rev=1412279&view=rev
Log:
DERBY-5999  Improve documentation on index key lengths 

Merged patch DERBY-5999-2.diff to 10.9 doc branch from trunk revision 1412196.

Modified:
    db/derby/docs/branches/10.9/src/ref/rrefsqlj41207.dita
    db/derby/docs/branches/10.9/src/tuning/ctundepth1002853.dita

Modified: db/derby/docs/branches/10.9/src/ref/rrefsqlj41207.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.9/src/ref/rrefsqlj41207.dita?rev=1412279&r1=1412278&r2=1412279&view=diff
==============================================================================
--- db/derby/docs/branches/10.9/src/ref/rrefsqlj41207.dita (original)
+++ db/derby/docs/branches/10.9/src/ref/rrefsqlj41207.dita Wed Nov 21 20:40:08 2012
@@ -38,7 +38,12 @@ an exception to be raised. When <xref hr
 VARCHARs, the lengths of the operands are not altered, and spaces at the end
 of the values are ignored.</p> <p>When CHARs and VARCHARs are mixed in expressions,
 the shorter value is padded with spaces to the length of the longer value.</p> <p>The
-type of a string constant is CHAR, not VARCHAR.</p> </section>
+type of a string constant is CHAR, not VARCHAR.</p>
+<p>If you use a VARCHAR as a key column of an index, limit the maximum size of
+the VARCHAR to no more than half the page size to prevent inserts from failing.
+See "Page size and key size" in
+<xref href="rrefsqlj20937.dita#rrefsqlj20937"></xref> for details.</p>
+</section>
 </refbody>
 </reference>
 

Modified: db/derby/docs/branches/10.9/src/tuning/ctundepth1002853.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.9/src/tuning/ctundepth1002853.dita?rev=1412279&r1=1412278&r2=1412279&view=diff
==============================================================================
--- db/derby/docs/branches/10.9/src/tuning/ctundepth1002853.dita (original)
+++ db/derby/docs/branches/10.9/src/tuning/ctundepth1002853.dita Wed Nov 21 20:40:08 2012
@@ -46,7 +46,12 @@ not have to go to the table at all. (See
 <li>For operations that require a sort (ORDER BY), if <ph conref="../conrefs.dita#prod/productshortname"></ph>
uses
 the index to retrieve the data, it does not have to perform a separate sorting
 step for some of these operations in some situations. (See <xref href="ctunoptimz27036.dita#ctunoptimz27036"></xref>.)</li>
-</ul> <note><ph conref="../conrefs.dita#prod/productshortname"></ph>
does
+</ul>
+</p>
+<p>See "CREATE INDEX statement" in the
+<ph conref="../conrefs.dita#pub/citref"></ph> for details on creating indexes,
+including restrictions on key size.</p>
+<p><note><ph conref="../conrefs.dita#prod/productshortname"></ph>
does
 not support indexing on columns with data types like BLOB, CLOB, and XML.</note></p>
 </conbody>
 </concept>



Mime
View raw message