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 da...@apache.org on 2009/08/31 17:47:24 UTC
svn commit: r809632 [6/7] - in /db/derby/code/trunk/java:
engine/org/apache/derby/iapi/util/
engine/org/apache/derby/impl/sql/execute/rts/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/tests/lang/ t...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out?rev=809632&r1=809631&r2=809632&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out Mon Aug 31 15:47:23 2009
@@ -86,7 +86,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -95,16 +95,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 4
get cursor c as
@@ -147,7 +147,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -156,16 +156,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 5
get cursor c as
@@ -208,7 +208,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -217,16 +217,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 6
get cursor c as
@@ -269,7 +269,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -278,16 +278,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 7
get cursor c as
@@ -332,7 +332,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -341,16 +341,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 12
get cursor c as
@@ -406,7 +406,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -415,14 +415,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -451,20 +451,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Wisconsin Query 13
get cursor c as
@@ -523,17 +523,19 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-None
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
<filtered number of opens>
@@ -552,7 +554,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -561,14 +563,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin query 14
-- NOTE: This could benefit from transitive closure, which our optimizer
@@ -635,21 +637,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 1
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 1
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
<filtered number of opens>
@@ -668,7 +672,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -677,20 +681,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -709,7 +713,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -718,25 +722,25 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
-Column[0][1] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
+ Column[0][1] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Wisconsin Query 15
get cursor c as
@@ -792,7 +796,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -801,14 +805,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -837,20 +841,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Wisconsin Query 16
get cursor c as
@@ -909,17 +913,19 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-None
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
<filtered number of opens>
@@ -938,7 +944,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -947,14 +953,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Wisconsin Query 17
-- NOTE: This could benefit from transitive closure, which our optimizer
@@ -1021,21 +1027,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
<filtered number of opens>
@@ -1054,7 +1062,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1063,20 +1071,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -1095,7 +1103,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1104,25 +1112,25 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
-Column[0][1] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
+ Column[0][1] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- This is the end of the Wisconsin queries. Now do some queries that are
-- not part of the original Wisconsin benchmark, using the Wisconsin schema.
@@ -1168,7 +1176,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1177,14 +1185,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 50% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -1227,7 +1235,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1236,14 +1244,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 100% of rows - should do table scan
get cursor c as
@@ -1278,21 +1286,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: <
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -1335,7 +1345,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1344,13 +1354,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 50% selectivity index that covers query - should do index scan
get cursor c as
@@ -1385,7 +1395,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -1394,14 +1404,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'four'
-- 25% selectivity index that doesn't cover query - should do index scan
@@ -1445,7 +1455,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1454,14 +1464,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 25% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -1504,7 +1514,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1513,14 +1523,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 75% of rows - should do table scan
get cursor c as
@@ -1555,21 +1565,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 3
-Operator: <
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 3
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -1612,7 +1624,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1621,13 +1633,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 25% selectivity index that covers query - should do index scan
get cursor c as
@@ -1662,7 +1674,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -1671,14 +1683,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'twentyPercent'
-- 20% selectivity index that doesn't cover query - should use index
@@ -1722,7 +1734,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1731,14 +1743,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 20% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -1781,7 +1793,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1790,14 +1802,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 60% of rows - should do table scan
get cursor c as
@@ -1832,21 +1844,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 8
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 8
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -1889,7 +1903,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -1898,13 +1912,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 20% selectivity index that covers query - should do index scan
get cursor c as
@@ -1939,7 +1953,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -1948,14 +1962,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'ten'
-- 10% selectivity index that doesn't cover query - should use index
@@ -1999,7 +2013,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2008,14 +2022,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 10% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -2058,7 +2072,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2067,14 +2081,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -2117,7 +2131,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2126,13 +2140,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ None
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 60% of rows - should do table scan
get cursor c as
@@ -2167,21 +2181,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 4
-Operator: <=
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 4
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -2224,7 +2240,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2233,13 +2249,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 10% selectivity index that covers query - should do index scan
get cursor c as
@@ -2274,7 +2290,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -2283,14 +2299,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'twenty'
-- 5% selectivity index that doesn't cover query - should use index
@@ -2334,7 +2350,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2343,14 +2359,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 5% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -2393,7 +2409,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2402,14 +2418,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -2452,7 +2468,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2461,13 +2477,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ None
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 55% of rows - should do table scan
get cursor c as
@@ -2502,21 +2518,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 5
-Operator: <=
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 5
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -2559,7 +2577,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2568,13 +2586,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 5% selectivity index that covers query - should do index scan
get cursor c as
@@ -2609,7 +2627,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -2618,14 +2636,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'onePercent'
-- 1% selectivity index that doesn't cover query - should use index
@@ -2669,7 +2687,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2678,14 +2696,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -2728,7 +2746,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2737,14 +2755,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -2779,21 +2797,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 6
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 6
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 60% of rows - should do table scan
get cursor c as
@@ -2828,21 +2848,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 6
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 6
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -2885,7 +2907,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -2894,13 +2916,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index that covers query - should do index scan
get cursor c as
@@ -2935,7 +2957,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -2944,14 +2966,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'evenOnePercent'
-- 1% selectivity index that doesn't cover query - should use index
@@ -2995,7 +3017,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3004,14 +3026,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -3054,7 +3076,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3063,14 +3085,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -3105,21 +3127,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 11
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 11
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 60% of rows - should do table scan
get cursor c as
@@ -3154,21 +3178,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 11
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 11
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -3211,7 +3237,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3220,13 +3246,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index that covers query - should do index scan
get cursor c as
@@ -3261,7 +3287,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -3270,14 +3296,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'oddOnePercent'
-- 1% selectivity index that doesn't cover query - should use index
@@ -3321,7 +3347,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3330,14 +3356,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -3380,7 +3406,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3389,14 +3415,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 40% of rows - should do index scan
get cursor c as
@@ -3439,7 +3465,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3448,13 +3474,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 60% of rows - should do table scan
get cursor c as
@@ -3489,21 +3515,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 12
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 12
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -3546,7 +3574,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3555,13 +3583,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 1% selectivity index that covers query - should do index scan
get cursor c as
@@ -3596,7 +3624,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -3605,14 +3633,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'stringu1'
-- unique index that doesn't cover query - should use index
@@ -3656,7 +3684,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3665,16 +3693,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- unique index with 0 matching rows - should do index scan
get cursor c as
@@ -3717,7 +3745,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3726,16 +3754,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -3770,21 +3798,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 13
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 13
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 51% of rows - should do table scan
get cursor c as
@@ -3819,21 +3849,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 13
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 13
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -3876,7 +3908,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3885,14 +3917,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- unique index that covers query - should do index scan
get cursor c as
@@ -3927,7 +3959,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -3936,16 +3968,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'stringu2'
-- unique index that doesn't cover query - should use index
@@ -3989,7 +4021,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -3998,16 +4030,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- unique index with 0 matching rows - should do index scan
get cursor c as
@@ -4050,7 +4082,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4059,16 +4091,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -4103,21 +4135,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 14
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 14
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 51% of rows - should do table scan
get cursor c as
@@ -4152,21 +4186,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 14
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 14
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -4209,7 +4245,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4218,14 +4254,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- unique index that covers query - should do index scan
get cursor c as
@@ -4260,7 +4296,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -4269,16 +4305,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Single-table queries using index on column 'string4'
-- 25% selectivity index that doesn't cover query - should do index scan
@@ -4322,7 +4358,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4331,14 +4367,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- 25% selectivity index with 0 matching rows - should do index scan
get cursor c as
@@ -4381,7 +4417,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4390,14 +4426,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- matches 50% of rows - should do index scan
get cursor c as
@@ -4432,21 +4468,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 15
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 15
+ Operator: <=
+ Ordered nulls: false
+ Unknown return value: true
+ Negate comparison result: true
ij> commit;
ij> -- matches 0 rows - should do index scan
get cursor c as
@@ -4489,7 +4527,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4498,13 +4536,13 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- None
+ start position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ None
qualifiers:
-None
+ None
ij> commit;
ij> -- 25% selectivity index that covers query - should do index scan
get cursor c as
@@ -4539,7 +4577,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
-scan information:
+scan information:
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
@@ -4548,14 +4586,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=3
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
qualifiers:
-None
+ None
ij> commit;
ij> -- Now test equijoins with different selectivities and different numbers
-- of outer rows. The approach taken is that different join columns are
@@ -4609,17 +4647,19 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-None
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -4638,7 +4678,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4647,16 +4687,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Join on unique1, 60% of rows in TENKTUP2
get cursor c as
@@ -4704,21 +4744,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -4737,7 +4779,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4746,20 +4788,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on unique1, 25% of rows in TENKTUP2
get cursor c as
@@ -4815,7 +4857,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4824,14 +4866,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -4860,20 +4902,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on unique1, 10% of rows in TENKTUP2
get cursor c as
@@ -4929,7 +4971,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -4938,14 +4980,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -4974,20 +5016,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on unique1, 5% of rows in TENKTUP2
get cursor c as
@@ -5043,7 +5085,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5052,14 +5094,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -5088,20 +5130,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on unique1, 1% of rows in TENKTUP2
get cursor c as
@@ -5157,7 +5199,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5166,14 +5208,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -5202,20 +5244,20 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
scan qualifiers:
-None
+ None
next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ Column[0][0] Id: 0
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on unique1, 1 row in TENKTUP2
get cursor c as
@@ -5271,7 +5313,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5280,16 +5322,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
<filtered number of opens>
@@ -5308,7 +5350,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5317,16 +5359,16 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
- stop position:
- > on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
+ stop position:
+ > on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
ij> commit;
ij> -- Joins on two
-- Join on two, all rows in TENKTUP2
@@ -5373,17 +5415,19 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-None
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ None
Right result set:
Table Scan ResultSet for TENKTUP2 at serializable isolation level using share table locking chosen by the optimizer
<filtered number of opens>
@@ -5394,21 +5438,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on two, 60% of rows in TENKTUP2
get cursor c as
@@ -5469,21 +5515,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 0
+ Operator: <
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
Right result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
<filtered number of opens>
@@ -5494,21 +5542,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on two, 25% of rows in TENKTUP2
get cursor c as
@@ -5577,7 +5627,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5586,14 +5636,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
<filtered number of opens>
@@ -5604,21 +5654,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on two, 10% of rows in TENKTUP2
get cursor c as
@@ -5687,7 +5739,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5696,14 +5748,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
<filtered number of opens>
@@ -5714,21 +5766,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on two, 5% of rows in TENKTUP2
get cursor c as
@@ -5797,7 +5851,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5806,14 +5860,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
- stop position:
- >= on first 1 column(s).
- Ordered null semantics on the following columns:
-0
+ start position:
+ None
+ stop position:
+ >= on first 1 column(s).
+ Ordered null semantics on the following columns:
+ 0
qualifiers:
-None
+ None
Right result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
<filtered number of opens>
@@ -5824,21 +5878,23 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=16
<filtered number of pages visited>
<filtered number of rows qualified>
<filtered number of rows visited>
Scan type=heap
- start position:
-null stop position:
-null qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+ start position:
+ null
+ stop position:
+ null
+ qualifiers:
+ Column[0][0] Id: 2
+ Operator: =
+ Ordered nulls: false
+ Unknown return value: false
+ Negate comparison result: false
ij> commit;
ij> -- Join on two, 1% of rows in TENKTUP2
get cursor c as
@@ -5907,7 +5963,7 @@
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- scan information:
+ scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
@@ -5916,14 +5972,14 @@
<filtered number of rows visited>
Scan type=btree
Tree height=2
- start position:
- None
[... 13005 lines stripped ...]