db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1412196 - in /db/derby/docs/trunk/src: ref/rrefsqlj41207.dita tuning/ctundepth1002853.dita
Date Wed, 21 Nov 2012 17:14:07 GMT
Author: chaase3
Date: Wed Nov 21 17:14:06 2012
New Revision: 1412196

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

Modified a Tuning Guide and a Reference Manual topic.

Patch: DERBY-5999-2.diff


Modified: db/derby/docs/trunk/src/ref/rrefsqlj41207.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj41207.dita?rev=1412196&r1=1412195&r2=1412196&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj41207.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj41207.dita Wed Nov 21 17:14:06 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>

Modified: db/derby/docs/trunk/src/tuning/ctundepth1002853.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctundepth1002853.dita?rev=1412196&r1=1412195&r2=1412196&view=diff
--- db/derby/docs/trunk/src/tuning/ctundepth1002853.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctundepth1002853.dita Wed Nov 21 17:14:06 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>
 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>
+<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>
 not support indexing on columns with data types like BLOB, CLOB, and XML.</note></p>

View raw message