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 ka...@apache.org on 2006/03/20 15:21:10 UTC
svn commit: r387214 [2/3] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/ master/DerbyNet/ master/DerbyNetClient/ tests/jdbcapi/ tests/lang/
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out?rev=387214&r1=387213&r2=387214&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 Mar 20 06:20:56 2006
@@ -1,4 +1,3 @@
-WARNING 01J01: Database 'wombat' not created, connection made to existing database instead.
ij> -- This test is an adaptation of the Wisconsin benchmark, as documented in
-- The Benchmark Handbook, Second Edition (edited by Jim Gray). The structure
-- of the tables and the data in the tables are taken from there.
@@ -55,16 +54,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -75,9 +74,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -116,16 +115,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -136,9 +135,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -177,16 +176,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -197,9 +196,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -238,16 +237,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -258,9 +257,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -301,16 +300,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -321,9 +320,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -364,41 +363,40 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Hash Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -411,18 +409,18 @@
None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE2 at serializable isolation level using share row locking:
- Number of opens = 1
+ <filtered number of opens>
Hash table size = 1000
Hash key is column number 0
- Rows seen = 0
+ <filtered rows seen>
Rows filtered = 0
constructor time (milliseconds) = 0
open time (milliseconds) = 0
@@ -432,9 +430,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=7
- Number of rows qualified=1000
- Number of rows visited=1001
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -477,8 +475,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Project-Restrict ResultSet (5):
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
restriction = false
projection = true
@@ -490,32 +488,31 @@
projection time (milliseconds) = 0
Source result set:
Nested Loop Exists Join ResultSet:
- Number of opens = 1
- Rows seen from the left = 1
- Rows seen from the right = 0
+ <filtered number of opens>
+ <filtered rows seen from the left>
+ <filtered rows seen from the right>
Rows filtered = 0
- Rows returned = 0
+ <filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for BPRIME at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -523,16 +520,16 @@
None
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -543,9 +540,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -592,43 +589,42 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Nested Loop Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Nested Loop Exists Join ResultSet:
- Number of opens = 1
- Rows seen from the left = 1
- Rows seen from the right = 1
+ <filtered number of opens>
+ <filtered rows seen from the left>
+ <filtered rows seen from the right>
Rows filtered = 0
- Rows returned = 1
+ <filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for ONEKTUP at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -640,30 +636,29 @@
Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=2
- Number of rows qualified=1
- Number of rows visited=1
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -682,16 +677,16 @@
Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -702,9 +697,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -754,41 +749,40 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Hash Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -801,18 +795,18 @@
None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Hash Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking:
- Number of opens = 1
+ <filtered number of opens>
Hash table size = 1000
Hash key is column number 0
- Rows seen = 0
+ <filtered rows seen>
Rows filtered = 0
constructor time (milliseconds) = 0
open time (milliseconds) = 0
@@ -822,9 +816,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=7
- Number of rows qualified=1000
- Number of rows visited=1001
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -867,8 +861,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Project-Restrict ResultSet (5):
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
restriction = false
projection = true
@@ -880,32 +874,31 @@
projection time (milliseconds) = 0
Source result set:
Nested Loop Exists Join ResultSet:
- Number of opens = 1
- Rows seen from the left = 1
- Rows seen from the right = 0
+ <filtered number of opens>
+ <filtered rows seen from the left>
+ <filtered rows seen from the right>
Rows filtered = 0
- Rows returned = 0
+ <filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for BPRIME at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -913,16 +906,16 @@
None
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -933,9 +926,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -982,43 +975,42 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Nested Loop Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Nested Loop Exists Join ResultSet:
- Number of opens = 1
- Rows seen from the left = 1
- Rows seen from the right = 1
+ <filtered number of opens>
+ <filtered rows seen from the left>
+ <filtered rows seen from the right>
Rows filtered = 0
- Rows returned = 1
+ <filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for ONEKTUP at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -1030,30 +1022,29 @@
Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP1:
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=2
- Number of rows qualified=1
- Number of rows visited=1
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1072,16 +1063,16 @@
Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -1092,9 +1083,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1145,16 +1136,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWO at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1165,9 +1156,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1204,16 +1195,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWO at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1224,9 +1215,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1263,8 +1254,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1274,9 +1265,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -1312,16 +1303,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWO at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1332,9 +1323,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1370,8 +1361,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1TWO at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1382,9 +1373,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1422,16 +1413,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1FOUR at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1442,9 +1433,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1481,16 +1472,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1FOUR at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1501,9 +1492,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1540,8 +1531,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1551,9 +1542,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -1589,16 +1580,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1FOUR at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1609,9 +1600,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1647,8 +1638,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1FOUR at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1659,9 +1650,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1699,16 +1690,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTYPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1719,9 +1710,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1758,16 +1749,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTYPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1778,9 +1769,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1817,8 +1808,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1828,9 +1819,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -1866,16 +1857,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTYPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1886,9 +1877,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1924,8 +1915,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1TWENTYPERCENT at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1936,9 +1927,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -1976,16 +1967,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TEN at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -1996,9 +1987,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2035,16 +2026,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TEN at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2055,9 +2046,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2094,16 +2085,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TEN at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2114,9 +2105,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2152,8 +2143,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2163,9 +2154,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -2201,16 +2192,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TEN at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2221,9 +2212,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2259,8 +2250,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1TEN at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2271,9 +2262,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2311,16 +2302,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTY at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2331,9 +2322,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2370,16 +2361,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTY at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2390,9 +2381,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2429,16 +2420,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTY at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2449,9 +2440,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2487,8 +2478,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2498,9 +2489,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -2536,16 +2527,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1TWENTY at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2556,9 +2547,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2594,8 +2585,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1TWENTY at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2606,9 +2597,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2646,16 +2637,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2666,9 +2657,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2705,16 +2696,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2725,9 +2716,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2764,8 +2755,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2775,9 +2766,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -2813,8 +2804,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2824,9 +2815,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -2862,16 +2853,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2882,9 +2873,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2920,8 +2911,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1ONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2932,9 +2923,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -2972,16 +2963,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1EVENONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -2992,9 +2983,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3031,16 +3022,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1EVENONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3051,9 +3042,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3090,8 +3081,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3101,9 +3092,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -3139,8 +3130,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3150,9 +3141,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -3188,16 +3179,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1EVENONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3208,9 +3199,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3246,8 +3237,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1EVENONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3258,9 +3249,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3298,16 +3289,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ODDONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3318,9 +3309,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3357,16 +3348,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ODDONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3377,9 +3368,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3416,16 +3407,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ODDONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3436,9 +3427,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3474,8 +3465,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3485,9 +3476,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -3523,16 +3514,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1ODDONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3543,9 +3534,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3581,8 +3572,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1ODDONEPERCENT at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3593,9 +3584,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -3633,16 +3624,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -3653,9 +3644,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -3694,16 +3685,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -3714,9 +3705,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -3755,8 +3746,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3766,9 +3757,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -3804,8 +3795,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3815,9 +3806,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -3853,16 +3844,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -3873,9 +3864,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -3912,8 +3903,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU1 at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -3924,9 +3915,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -3966,16 +3957,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -3986,9 +3977,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4027,16 +4018,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -4047,9 +4038,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4088,8 +4079,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4099,9 +4090,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -4137,8 +4128,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4148,9 +4139,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -4186,16 +4177,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU2 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4206,9 +4197,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4245,8 +4236,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1STRINGU2 at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -4257,9 +4248,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4299,16 +4290,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRING4 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4319,9 +4310,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4358,16 +4349,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRING4 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4378,9 +4369,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4417,8 +4408,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4428,9 +4419,9 @@
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -4466,16 +4457,16 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Row to Base Row ResultSet for TENKTUP1:
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP1 using index TK1STRING4 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4486,9 +4477,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4524,8 +4515,8 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Index Scan ResultSet for TENKTUP1 using index TK1STRING4 at serializable isolation level using share row locking chosen by the optimizer
-Number of opens = 1
-Rows seen = 0
+<filtered number of opens>
+<filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
@@ -4536,9 +4527,9 @@
Bit set of columns fetched={0}
Number of columns fetched=1
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=3
start position:
@@ -4583,32 +4574,31 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Nested Loop Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=2
- Number of rows qualified=16
- Number of rows visited=16
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -4616,16 +4606,16 @@
None
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Index Scan ResultSet for TENKTUP2 using index TK2UNIQUE1 at serializable isolation level using share row locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 1
constructor time (milliseconds) = 0
@@ -4636,9 +4626,9 @@
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
- Number of pages visited=0
- Number of rows qualified=0
- Number of rows visited=0
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=btree
Tree height=2
start position:
@@ -4679,32 +4669,31 @@
End Execution Timestamp : null
Statement Execution Plan Text:
Nested Loop Exists Join ResultSet:
-Number of opens = 1
-Rows seen from the left = 1
-Rows seen from the right = 0
+<filtered number of opens>
+<filtered rows seen from the left>
+<filtered rows seen from the right>
Rows filtered = 0
-Rows returned = 0
+<filtered rows returned>
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
Left result set:
Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
- Number of opens = 1
- Rows seen = 1
+ <filtered number of opens>
+ <filtered rows seen>
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
- next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=16
- Number of pages visited=3
- Number of rows qualified=16
- Number of rows visited=27
+ <filtered number of pages visited>
+ <filtered number of rows qualified>
+ <filtered number of rows visited>
Scan type=heap
start position:
null stop position:
@@ -4716,16 +4705,16 @@
Negate comparison result: false
Right result set:
Index Row to Base Row ResultSet for TENKTUP2:
- Number of opens = 1
- Rows seen = 0
+ <filtered number of opens>
+ <filtered rows seen>
Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
[... 19932 lines stripped ...]