You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2005/07/01 00:34:59 UTC
svn commit: r208690 [1/3] - /incubator/derby/docs/trunk/src/tuning/
Author: fuzzylogic
Date: Thu Jun 30 15:34:50 2005
New Revision: 208690
URL: http://svn.apache.org/viewcvs?rev=208690&view=rev
Log:
DERBY-384: Changes from review of Tuning Derby
Committed for Jeff Levitt <de...@mylevita.com>
Modified:
incubator/derby/docs/trunk/src/tuning/ctundepth1002853.dita
incubator/derby/docs/trunk/src/tuning/ctundepth1003116.dita
incubator/derby/docs/trunk/src/tuning/ctundepth1003209.dita
incubator/derby/docs/trunk/src/tuning/ctundepth1003369.dita
incubator/derby/docs/trunk/src/tuning/ctundepth1003672.dita
incubator/derby/docs/trunk/src/tuning/ctundepth10525.dita
incubator/derby/docs/trunk/src/tuning/ctundepth13055.dita
incubator/derby/docs/trunk/src/tuning/ctundepth14326.dita
incubator/derby/docs/trunk/src/tuning/ctundepth21935.dita
incubator/derby/docs/trunk/src/tuning/ctundepth23033.dita
incubator/derby/docs/trunk/src/tuning/ctundepth26674.dita
incubator/derby/docs/trunk/src/tuning/ctundepth29804.dita
incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita
incubator/derby/docs/trunk/src/tuning/ctundepth36205.dita
incubator/derby/docs/trunk/src/tuning/ctundepth37648.dita
incubator/derby/docs/trunk/src/tuning/ctundepth39739.dita
incubator/derby/docs/trunk/src/tuning/ctundepth853095.dita
incubator/derby/docs/trunk/src/tuning/ctundepth853133.dita
incubator/derby/docs/trunk/src/tuning/ctundepth853228.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz1004264.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz1004373.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz1008884.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz1011736.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz11775.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz11941.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz12168.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz19357.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz20327.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz22111.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz22460.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz22900.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz23173.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz23977.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz24840.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz26019.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz27036.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz27975.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz29384.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz30217.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz30768.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz32184.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz32767.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz33368.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz39106.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz39739.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz41314.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz42065.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz42425.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz56859.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz856914.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz857385.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz859947.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz859974.dita
incubator/derby/docs/trunk/src/tuning/ctunoptimz860097.dita
incubator/derby/docs/trunk/src/tuning/ctunperf1004126.dita
incubator/derby/docs/trunk/src/tuning/ctunperf1004182.dita
incubator/derby/docs/trunk/src/tuning/ctunperf10065.dita
incubator/derby/docs/trunk/src/tuning/ctunperf10679.dita
incubator/derby/docs/trunk/src/tuning/ctunperf16556.dita
incubator/derby/docs/trunk/src/tuning/ctunperf16800.dita
incubator/derby/docs/trunk/src/tuning/ctunperf17936.dita
incubator/derby/docs/trunk/src/tuning/ctunperf18705.dita
incubator/derby/docs/trunk/src/tuning/ctunperf22457.dita
incubator/derby/docs/trunk/src/tuning/ctunperf23868.dita
incubator/derby/docs/trunk/src/tuning/ctunperf25864.dita
incubator/derby/docs/trunk/src/tuning/ctunperf31086.dita
incubator/derby/docs/trunk/src/tuning/ctunperf54492.dita
incubator/derby/docs/trunk/src/tuning/ctunperf816059.dita
incubator/derby/docs/trunk/src/tuning/ctunperf816635.dita
incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita
incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita
incubator/derby/docs/trunk/src/tuning/ctunproper51399.dita
incubator/derby/docs/trunk/src/tuning/ctunpropref1002477.dita
incubator/derby/docs/trunk/src/tuning/ctunpropref11181.dita
incubator/derby/docs/trunk/src/tuning/ctunpropref22460.dita
incubator/derby/docs/trunk/src/tuning/ctunpropref23947.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop1003847.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop11108.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop11561.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop12821.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop13074.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop16827.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop23308.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop24222.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop24843.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop32443.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop34818.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop38343.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop44147.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop824451.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop824500.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop824533.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop824615.dita
incubator/derby/docs/trunk/src/tuning/ctunsetprop824983.dita
incubator/derby/docs/trunk/src/tuning/ctunstats18908.dita
incubator/derby/docs/trunk/src/tuning/ctunstats46438.dita
incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita
incubator/derby/docs/trunk/src/tuning/ctunstats57373.dita
incubator/derby/docs/trunk/src/tuning/ctunstats57793.dita
incubator/derby/docs/trunk/src/tuning/ctunstats60669.dita
incubator/derby/docs/trunk/src/tuning/ctunstats72938.dita
incubator/derby/docs/trunk/src/tuning/ctunstats848901.dita
incubator/derby/docs/trunk/src/tuning/ctunstats848961.dita
incubator/derby/docs/trunk/src/tuning/ctunstats849000.dita
incubator/derby/docs/trunk/src/tuning/ctunstats849203.dita
incubator/derby/docs/trunk/src/tuning/ctunstats849251.dita
incubator/derby/docs/trunk/src/tuning/ctunstats849505.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform11313.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform13699.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform14044.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform16033.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform21780.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform22576.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform25857.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform25868.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform35783.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform36368.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform36623.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform37032.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform41535.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform47182.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform55045.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform867165.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita
incubator/derby/docs/trunk/src/tuning/rtuncopyright.dita
incubator/derby/docs/trunk/src/tuning/rtunoptimz1004602.dita
incubator/derby/docs/trunk/src/tuning/rtunoptimz1004810.dita
incubator/derby/docs/trunk/src/tuning/rtunproper10607.dita
incubator/derby/docs/trunk/src/tuning/rtunproper13217.dita
incubator/derby/docs/trunk/src/tuning/rtunproper13766.dita
incubator/derby/docs/trunk/src/tuning/rtunproper18151.dita
incubator/derby/docs/trunk/src/tuning/rtunproper23835.dita
incubator/derby/docs/trunk/src/tuning/rtunproper24390.dita
incubator/derby/docs/trunk/src/tuning/rtunproper24846.dita
incubator/derby/docs/trunk/src/tuning/rtunproper25025.dita
incubator/derby/docs/trunk/src/tuning/rtunproper25581.dita
incubator/derby/docs/trunk/src/tuning/rtunproper26978.dita
incubator/derby/docs/trunk/src/tuning/rtunproper26985.dita
incubator/derby/docs/trunk/src/tuning/rtunproper27355.dita
incubator/derby/docs/trunk/src/tuning/rtunproper27467.dita
incubator/derby/docs/trunk/src/tuning/rtunproper27529.dita
incubator/derby/docs/trunk/src/tuning/rtunproper28026.dita
incubator/derby/docs/trunk/src/tuning/rtunproper32066.dita
incubator/derby/docs/trunk/src/tuning/rtunproper32213.dita
incubator/derby/docs/trunk/src/tuning/rtunproper33027.dita
incubator/derby/docs/trunk/src/tuning/rtunproper34037.dita
incubator/derby/docs/trunk/src/tuning/rtunproper35028.dita
incubator/derby/docs/trunk/src/tuning/rtunproper37341.dita
incubator/derby/docs/trunk/src/tuning/rtunproper39325.dita
incubator/derby/docs/trunk/src/tuning/rtunproper40346.dita
incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita
incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita
incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita
incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita
incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita
incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita
incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita
incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita
incubator/derby/docs/trunk/src/tuning/rtunproperdurability.dita
incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita
incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita
incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita
incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform582.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform590.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform866214.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform866547.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform866587.dita
incubator/derby/docs/trunk/src/tuning/rtuntransform867602.dita
incubator/derby/docs/trunk/src/tuning/ttundepth33391.dita
incubator/derby/docs/trunk/src/tuning/ttundepth34375.dita
incubator/derby/docs/trunk/src/tuning/tunconrefs.dita
incubator/derby/docs/trunk/src/tuning/tuningderby.ditamap
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth1002853.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth1002853.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth1002853.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth1002853.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -33,8 +33,7 @@
</ul></p>
<p>For an index to be useful for a particular statement, one of the columns
in the statement's WHERE clause must be the first column in the index's key.
- <note>For a complete discussion of how indexes work and when they are useful
-(including pictures), see <xref href="ctunoptimz33368.dita#ctunoptimz33368"></xref> and <xref
+ <note>For a complete discussion of how indexes work and when they are useful, see <xref href="ctunoptimz33368.dita#ctunoptimz33368"></xref> and <xref
href="ctunoptimz30217.dita#ctunoptimz30217"></xref>.</note></p>
<p>Indexes provide some other benefits as well: <ul>
<li>If all the data requested are in the index, <ph conref="tunconrefs.dita#prod/productshortname"></ph> does not have to go
@@ -42,7 +41,7 @@
<li>For operations that require a sort (ORDER BY), if <ph conref="tunconrefs.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="tunconrefs.dita#prod/productshortname"></ph> does not support indexing long columns.</note></p>
+</ul> <note><ph conref="tunconrefs.dita#prod/productshortname"></ph> does not support indexing long columns like CLOB and BLOB.</note></p>
</conbody>
</concept>
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth1003116.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth1003116.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth1003116.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth1003116.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth1003209.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth1003209.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth1003209.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth1003209.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -27,13 +27,8 @@
<conbody>
<p><ph conref="tunconrefs.dita#prod/productshortname"></ph> allows you to create index columns in descending order in addition
to creating them in ascending order, the default. Descending indexes provide
-performance benefits for the following kinds of queries:
-<ul>
-<li>Queries that require sorting data in descending order. </li>
-<li>Queries that return the minimum or maximum value. </li>
-</ul></p>
-<p>Such indexes can also be used in the same way that ascending indexes are.</p>
+performance benefits for the following kinds of queries that require sorting data in descending order.</p>
<p>To ensure performance benefits, verify that the descending index is being
-used. Force the index if necessary. See <xref href="ttundepth33391.dita#ttundepth33391"/> for
+used. See <xref href="ttundepth33391.dita#ttundepth33391"/> for
information on how to do this. </p>
</conbody></concept>
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth1003369.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth1003369.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth1003369.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth1003369.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -26,17 +26,16 @@
<conbody>
<p>For some queries, join order can make the difference between a table scan
(expensive) and an index scan (cheap). Here's an example:
-<codeblock><b>select fts.flight_id, fa.flight_date, fts.depart_time
-from flights fts, flightavailability fa
-where fts.flight_id = fa.flight_id and
-fts.segment_number = fa.segment_number
-and fts.dest_airport = 'CDG'
-and fts.orig_airport = 'DUB'
-order by flight_date</b></codeblock></p>
+<codeblock><b>select ht.hotel_id, ha.stay_date, ht.depart_time
+from hotels ht, Hotelavailability ha
+where ht.hotel_id = ha.hotel_id and
+ht.room_number = ha.room_number
+and ht.bed_type = 'KING'
+and ht.smoking_room = 'NO'
+order by ha.stay_date</b></codeblock></p>
<p>If <ph conref="tunconrefs.dita#prod/productshortname"></ph> chooses <i>Hotels</i> as the outer table,
it can use the index on <i>Hotels</i> to retrieve qualifying
-rows. (Given the data in <i>toursDB</i>, it will return three
-rows; three hotels have a <i>city_id</i> of 10.) Then it
+rows. Then it
need only look up data in <i>HotelAvailability</i> three
times, once for each qualifying row. And to retrieve the appropriate rows
from <i>HotelAvailability</i>, it can use an index for <i>HotelAvailability</i>'s <i>hotel_id</i> column
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth1003672.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth1003672.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth1003672.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth1003672.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -32,7 +32,7 @@
indexes that use descending ordering:
<codeblock><b><ph>-- would benefit from an index like this:
-- CREATE INDEX c_id_desc ON Citites(city_id DESC)</ph>
-SELECT * FROM Cities ORDER BY citiy_id DESC
+SELECT * FROM Cities ORDER BY city_id DESC
<ph>-- would benefit from an index like this:
-- CREATE INDEX f_miles_desc on Flights(miles DESC)</ph>
SELECT MAX(miles) FROM Flight
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth10525.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth10525.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth10525.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth10525.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth13055.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth13055.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth13055.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth13055.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth14326.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth14326.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth14326.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth14326.dita Thu Jun 30 15:34:50 2005
@@ -2,7 +2,7 @@
<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
"../dtd/concept.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth21935.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth21935.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth21935.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth21935.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth23033.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth23033.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth23033.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth23033.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -16,7 +16,7 @@
-->
<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN" "../dtd/concept.dtd">
<concept xml:lang="en-us" id="ctundepth23033">
-<title>Index, index, index</title>
+<title>Always create indexes</title>
<prolog><metadata>
<keywords>
<indexterm>Indexes<indexterm>performance benefits of</indexterm></indexterm>
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth26674.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth26674.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth26674.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth26674.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth29804.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth29804.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth29804.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth29804.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth36205.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth36205.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth36205.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth36205.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth37648.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth37648.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth37648.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth37648.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth39739.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth39739.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth39739.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth39739.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth853095.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth853095.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth853095.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth853095.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth853133.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth853133.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth853133.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth853133.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -51,10 +51,10 @@
Generate Time: 20
Compile Time: 100
Execute Time: 10
-Begin Compilation Timestamp : 2004-05-25 09:16:21.24
-End Compilation Timestamp : 2004-05-25 09:16:21.34
-Begin Execution Timestamp : 2004-05-25 09:16:21.35
-End Execution Timestamp : 2004-05-25 09:16:21.4
+Begin Compilation Timestamp : 2005-05-25 09:16:21.24
+End Compilation Timestamp : 2005-05-25 09:16:21.34
+Begin Execution Timestamp : 2005-05-25 09:16:21.35
+End Execution Timestamp : 2005-05-25 09:16:21.4
Statement Execution Plan Text:
Table Scan ResultSet for COUNTRIES at read committed isolation
level using instntaneous share row
@@ -103,10 +103,10 @@
Generate Time: 10
Compile Time: 390
Execute Time: 0
-Begin Compilation Timestamp : 2004-05-25 09:20:41.274
-End Compilation Timestamp : 2004-05-25 09:20:41.664
-Begin Execution Timestamp : 2004-05-25 09:20:41.674
-End Execution Timestamp : 2004-05-25 09:20:41.674
+Begin Compilation Timestamp : 2005-05-25 09:20:41.274
+End Compilation Timestamp : 2005-05-25 09:20:41.664
+Begin Execution Timestamp : 2005-05-25 09:20:41.674
+End Execution Timestamp : 2005-05-25 09:20:41.674
Statement Execution Plan Text:
Project-Restrict ResultSet (2):
Number of opens = 1
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth853228.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth853228.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth853228.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth853228.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz1004264.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz1004264.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz1004264.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz1004264.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz1004373.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz1004373.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz1004373.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz1004373.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz1008884.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz1008884.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz1008884.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz1008884.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz1011736.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz1011736.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz1011736.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz1011736.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz11775.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz11775.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz11775.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz11775.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz11941.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz11941.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz11941.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz11941.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz12168.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz12168.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz12168.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz12168.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz19357.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz19357.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz19357.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz19357.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz20327.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz20327.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz20327.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz20327.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz22111.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz22111.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz22111.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz22111.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz22460.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz22460.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz22460.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz22460.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz22900.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz22900.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz22900.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz22900.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz23173.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz23173.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz23173.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz23173.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -50,7 +50,7 @@
Simple column references are described in <xref href="ctunoptimz24840.dita#ctunoptimz24840"/>.</li>
</ul></p>
<p>The hash table for a hash join is held in memory and if it gets big enough,
-it can cause the JVM to run out of memory. The optimizer makes a very rough
+it will spill to the disk. The optimizer makes a very rough
estimate of the amount of memory required to make the hash table. If it estimates
that the amount of memory required would exceed the system-wide limit of memory
use for a table, the optimizer chooses a nested loop join instead. </p>
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz23977.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz23977.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz23977.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz23977.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz24840.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz24840.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz24840.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz24840.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz26019.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz26019.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz26019.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz26019.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz27036.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz27036.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz27036.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz27036.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz27975.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz27975.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz27975.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz27975.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz29384.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz29384.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz29384.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz29384.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz30217.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz30217.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz30217.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz30217.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz30768.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz30768.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz30768.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz30768.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz32184.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz32184.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz32184.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz32184.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz32767.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz32767.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz32767.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz32767.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz33368.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz33368.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz33368.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz33368.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -26,8 +26,8 @@
</prolog>
<conbody>
<p>An index is a database structure that provides quick lookup of data in
-a column or columns of a table. It is probably best described through examples.</p>
-<p>For example, the <i>Flights</i> table in the <i>toursDB</i> database has three indexes:
+a column or columns of a table.</p>
+<p>For example, a <i>Flights</i> table in a <i>travelDB</i> database has three indexes:
<ul>
<li>An index on the <i>orig_airport</i> column (called <i>OrigIndex</i>)</li>
<li>An index on the <i>dest_airport</i> column (called <i>DestIndex</i>)</li>
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz39106.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz39106.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz39106.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz39106.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz39739.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz39739.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz39739.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz39739.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz41314.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz41314.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz41314.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz41314.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz42065.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz42065.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz42065.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz42065.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz42425.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz42425.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz42425.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz42425.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz56859.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz56859.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz56859.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz56859.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz856914.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz856914.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz856914.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz856914.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz857385.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz857385.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz857385.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz857385.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz859947.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz859947.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz859947.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz859947.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz859974.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz859974.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz859974.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz859974.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunoptimz860097.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunoptimz860097.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunoptimz860097.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunoptimz860097.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf1004126.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf1004126.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf1004126.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf1004126.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf1004182.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf1004182.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf1004182.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf1004182.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf10065.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf10065.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf10065.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf10065.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf10679.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf10679.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf10679.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf10679.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf16556.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf16556.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf16556.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf16556.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf16800.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf16800.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf16800.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf16800.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,8 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -14,24 +16,22 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN" "../dtd/concept.dtd">
-<concept xml:lang="en-us" id="ctunperf16800">
+<concept id="ctunperf16800" xml:lang="en-us">
<title>Avoid inserts in autocommit mode if possible</title>
<prolog><metadata>
-<keywords>
-<indexterm>autocommit mode</indexterm>
-</keywords>
-</metadata>
-</prolog>
+<keywords><indexterm>autocommit mode</indexterm></keywords>
+</metadata></prolog>
<conbody>
<p>Inserts can be painfully slow in autocommit mode because each commit involves
an update of the log on the disk for each INSERT statement. The commit will
-not return until a physical disk write is executed. To speed things up:
-<ul>
+not return until a physical disk write is executed. To speed things up: <ul>
<li>Run in autocommit false mode, execute a number of inserts in one transaction,
and then explicitly issue a commit.</li>
<li>If your application allows an initial load into the table, you can use
-the import procedures to insert data into a table. See the <cite><ph conref="tunconrefs.dita#pub/citutilities"></ph> Guide</cite> for more information on the import procedures.</li>
-</ul><ph conref="tunconrefs.dita#prod/productshortname"></ph> will not log the individual inserts when loading
-into an empty table using these interfaces.</p>
-</conbody></concept>
+the import procedures to insert data into a table. <ph conref="tunconrefs.dita#prod/productshortname"></ph> will
+not log the individual inserts when loading into an empty table using these
+interfaces. See the <cite><ph conref="tunconrefs.dita#pub/citutilities"></ph> Guide</cite> for
+more information on the import procedures.</li>
+</ul></p>
+</conbody>
+</concept>
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf17936.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf17936.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf17936.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf17936.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf18705.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf18705.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf18705.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf18705.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf22457.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf22457.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf22457.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf22457.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf23868.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf23868.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf23868.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf23868.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf25864.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf25864.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf25864.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf25864.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf31086.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf31086.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf31086.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf31086.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf54492.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf54492.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf54492.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf54492.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf816059.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf816059.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf816059.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf816059.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -26,7 +26,7 @@
</prolog>
<conbody>
<p>Using large database pages benefits database performance, notably decreasing
-I/O time. By default, the database page size is 4096 bytes. You can change
+I/O time. <ph conref="tunconrefs.dita#prod/productshortname"></ph> autotunes the database pagesize. If you have long columns, the default pagesize for the table is set to 32K. Otherwise, the default is 4K. You can change
the default database page size with the <i><xref href="rtunproper40688.dita#rtunproper40688">derby.storage.pageSize</xref></i> property. For example:
<codeblock><b>derby.storage.pageSize=8192</b></codeblock></p>
<note>Large database pages require more memory.</note>
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf816635.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf816635.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf816635.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf816635.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita Thu Jun 30 15:34:50 2005
@@ -2,7 +2,7 @@
<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
"../dtd/concept.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunproper51399.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunproper51399.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunproper51399.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunproper51399.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,8 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
@@ -14,30 +16,31 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN" "../dtd/concept.dtd">
-<concept xml:lang="en-us" id="ctunproper51399">
+<concept id="ctunproper51399" xml:lang="en-us">
<title>Scope of Derby properties</title>
-<prolog>
-</prolog>
+<prolog></prolog>
<conbody>
-<p>A property in <ph conref="tunconrefs.dita#prod/productshortname"></ph> belongs to one or more of these scopes (for more
-information about scopes, precedence, and persistence, see <xref href="ctunsetprop11108.dita#ctunsetprop11108"/>):
-<ul id="i1008301">
-<li id="rtunproper41229"><i>system-wide</i>
-<p>System-wide properties apply to an entire
-system, including all its databases and tables if applicable.</p>
-<ul id="i1012032" compact="yes">
-<li id="rtunproper39976">Set programmatically</li>
-</ul>
-<p>System-wide properties set programmatically have precedence over database-wide
-properties and system-wide properties set in the <i>derby.properties</i> file.</p>
-<ul compact="yes">
-<li>Set in the <i>derby.properties</i> file</li>
+<p>A property in <ph conref="tunconrefs.dita#prod/productshortname"></ph> belongs
+to one or more of these scopes:<ul id="i1008301">
+<li id="rtunproper41229"><i>system-wide</i> <p>System-wide properties apply
+to an entire system, including all its databases and tables if applicable.</p><ul
+compact="yes" id="i1012032">
+<li id="rtunproper39976">Set programmatically<p>System-wide properties set
+programmatically have precedence over database-wide properties and system-wide
+properties set in the <i>derby.properties</i> file.</p></li>
+<li>Set in the <i>derby.properties</i> file<p>The <i>derby.properties</i> file
+is an optional file that can be created to set properties at the system level
+when the <ph conref="tunconrefs.dita#prod/productshortname"></ph> driver is
+loaded. <ph conref="tunconrefs.dita#prod/productshortname"></ph> looks for
+this file in the directory defined by the derby.system.home property. Any
+property except derby.system.home can be set by including it in the <i>derby.properties</i> file.</p></li>
</ul></li>
-<li id="rtunproper15705"><i>database-wide</i>
-<p>A database-wide property is stored in
-a database and is valid for that specific database only.</p>
-<note>Database-wide properties are stored in the database and are simpler for deployment.
-System-wide parameters are probably easier for development.</note></li>
+<li id="rtunproper15705"><i>database-wide</i> <p>A database-wide property
+is stored in a database and is valid for that specific database only.</p><note>Database-wide
+properties are stored in the database and are simpler for deployment. System-wide
+parameters are probably easier for development.</note></li>
</ul></p>
-</conbody></concept>
+<p>For more information about scopes, precedence, and persistence, see <xref
+href="ctunsetprop11108.dita#ctunsetprop11108"></xref></p>
+</conbody>
+</concept>
Modified: incubator/derby/docs/trunk/src/tuning/ctunpropref1002477.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunpropref1002477.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunpropref1002477.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunpropref1002477.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunpropref11181.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunpropref11181.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunpropref11181.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunpropref11181.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunpropref22460.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunpropref22460.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunpropref22460.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunpropref22460.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunpropref23947.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunpropref23947.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunpropref23947.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunpropref23947.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunsetprop1003847.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunsetprop1003847.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunsetprop1003847.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunsetprop1003847.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunsetprop11108.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunsetprop11108.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunsetprop11108.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunsetprop11108.dita Thu Jun 30 15:34:50 2005
@@ -2,7 +2,7 @@
<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
"../dtd/concept.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunsetprop11561.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunsetprop11561.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunsetprop11561.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunsetprop11561.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
Modified: incubator/derby/docs/trunk/src/tuning/ctunsetprop12821.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunsetprop12821.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunsetprop12821.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunsetprop12821.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.