Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 24461 invoked from network); 20 Mar 2006 14:23:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 20 Mar 2006 14:23:02 -0000 Received: (qmail 81398 invoked by uid 500); 20 Mar 2006 14:22:59 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 81309 invoked by uid 500); 20 Mar 2006 14:22:58 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 81134 invoked by uid 99); 20 Mar 2006 14:22:57 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Mar 2006 06:22:57 -0800 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 20 Mar 2006 06:22:53 -0800 Received: (qmail 23916 invoked by uid 65534); 20 Mar 2006 14:22:31 -0000 Message-ID: <20060320142230.23915.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: 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/ Date: Mon, 20 Mar 2006 14:21:10 -0000 To: derby-commits@db.apache.org From: kahatlen@apache.org X-Mailer: svnmailer-1.0.7 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + + Rows filtered = 0 -Rows returned = 0 + 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 + + 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 + + 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 + + + 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 + + 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 + Hash table size = 1000 Hash key is column number 0 - Rows seen = 0 + 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 + + + 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 + + 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 + + + Rows filtered = 0 - Rows returned = 0 + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + + Rows filtered = 0 -Rows returned = 0 + 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 + + + Rows filtered = 0 - Rows returned = 1 + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + + Rows filtered = 0 -Rows returned = 0 + 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 + + 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 + + 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 + + + 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 + + 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 + Hash table size = 1000 Hash key is column number 0 - Rows seen = 0 + 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 + + + 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 + + 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 + + + Rows filtered = 0 - Rows returned = 0 + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + + Rows filtered = 0 -Rows returned = 0 + 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 + + + Rows filtered = 0 - Rows returned = 1 + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + + 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 + + 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 + + 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 +