| ij> -- |
| -- Licensed to the Apache Software Foundation (ASF) under one or more |
| -- contributor license agreements. See the NOTICE file distributed with |
| -- this work for additional information regarding copyright ownership. |
| -- The ASF licenses this file to You under the Apache License, Version 2.0 |
| -- (the "License"); you may not use this file except in compliance with |
| -- the License. You may obtain a copy of the License at |
| -- |
| -- http://www.apache.org/licenses/LICENSE-2.0 |
| -- |
| -- Unless required by applicable law or agreed to in writing, software |
| -- distributed under the License is distributed on an "AS IS" BASIS, |
| -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| -- See the License for the specific language governing permissions and |
| -- limitations under the License. |
| -- |
| -- Test prints query plans for SpecjAppServer2001 benchmark queries. |
| -- Specifically this test checks for plans generated for tables with no rows to |
| -- ensure that |
| -- Index scan must be chosen over table scan for searched update/delete even when there are |
| -- 0 rows in table |
| -- Also see Beetle task id : 5006 |
| -- Test does the following |
| -- 1. First creates the necessary schema (tables, indexes) |
| -- 2. Executes and prints the query plan for all the queries in specjappserver2001 benchmark |
| -- Makes sure that the insert stmts are in the end to ensure that there are no |
| -- rows in the tables |
| -- 3. Drops the tables |
| -- Let's start with something light... |
| -- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to false for this connection. |
| NoHoldForConnection; |
| ij> drop table t1; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist. |
| ij> create table t1(c1 int, c2 int); |
| 0 rows inserted/updated/deleted |
| ij> -- create non-unique index first, then unique, to make sure non-unique is looked at first, and so |
| -- in case of tie, the first (nonunique) would be chosen by the cost-based optimizer. But we need |
| -- to make sure such tie never happens, and unique index is always chosen (if the only difference |
| -- between the two is "uniqueness"). Well the beetle bug 5006 itself is about, first of all, |
| -- table scan should never be chosen, no matter the index is covering ot not. |
| create index i11 on t1(c1); |
| 0 rows inserted/updated/deleted |
| ij> create unique index i12 on t1(c1); |
| 0 rows inserted/updated/deleted |
| ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1); |
| 0 rows inserted/updated/deleted |
| ij> maximumdisplaywidth 3500; |
| ij> -- In the following statement, optimizer thinks we have a covering index (only referenced column is |
| -- c1), make sure we are using unique index (I12), not table scan, not I11. |
| delete from t1 where c1 = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- In the following statement, optimizer thinks we have a covering index (only referenced column is |
| -- c1), make sure we are using unique index (I12), not table scan, not I11. |
| delete from t1 where c1 = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Delete ResultSet using row locking: |
| deferred: false |
| Rows deleted = 0 |
| Indexes updated = 2 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (1): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for T1 using index I12 at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={0, 1} |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| qualifiers: |
| None |
| ij> -- In the following statement, optimizer thinks we have a non-covering index (referenced columns are |
| -- c1 and c2), make sure we are still using unique index (I12), not table scan, not I11. |
| update t1 set c2 = 1 where c1 = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- In the following statement, optimizer thinks we have a non-covering index (referenced columns are |
| -- c1 and c2), make sure we are still using unique index (I12), not table scan, not I11. |
| update t1 set c2 = 1 where c1 = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for T1: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for T1 using index I12 at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| qualifiers: |
| None |
| ij> -- The following select should use TABLE SCAN, no predicate at all, and index not covering, no reason |
| -- to use index!!! |
| select * from t1; |
| C1 |C2 |
| ----------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- The following select should use TABLE SCAN, no predicate at all, and index not covering, no reason |
| -- to use index!!! |
| select * from t1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=heap |
| start position: |
| null |
| stop position: |
| null |
| qualifiers: |
| None |
| ij> -- This one should use index, since it is covered, really doesn't matter which one, since no predicate, |
| -- It will choose the first one -- I11. |
| select c1 from t1; |
| C1 |
| ----------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- This one should use index, since it is covered, really doesn't matter which one, since no predicate, |
| -- It will choose the first one -- I11. |
| select c1 from t1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Scan ResultSet for T1 using index I11 at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={0} |
| Number of columns fetched=1 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> drop table t1; |
| 0 rows inserted/updated/deleted |
| ij> -- end of something light... |
| DROP TABLE C_customer; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_CUSTOMER' because it does not exist. |
| ij> CREATE TABLE C_customer |
| ( |
| c_id integer not null, |
| c_first char(16), |
| c_last char(16), |
| c_street1 char(20), |
| c_street2 char(20), |
| c_city char(20), |
| c_state char(2), |
| c_country char(10), |
| c_zip char(9), |
| c_phone char(16), |
| c_contact char(25), |
| c_since date, |
| c_balance numeric(9,2), |
| c_credit char(2), |
| c_credit_limit numeric(9,2), |
| c_ytd_payment numeric(9,2) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_c_idx ON C_customer (c_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_supplier; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_SUPPLIER' because it does not exist. |
| ij> CREATE TABLE C_supplier |
| ( |
| supp_id integer not null, |
| supp_name char(16), |
| supp_street1 char(20), |
| supp_street2 char(20), |
| supp_city char(20), |
| supp_state char(2), |
| supp_country char(10), |
| supp_zip char(9), |
| supp_phone char(16), |
| supp_contact char(25) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_supp_idx ON C_supplier (supp_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_site; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_SITE' because it does not exist. |
| ij> CREATE TABLE C_site |
| ( |
| site_id integer not null, |
| site_name char(16), |
| site_street1 char(20), |
| site_street2 char(20), |
| site_city char(20), |
| site_state char(2), |
| site_country char(10), |
| site_zip char(9) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_site_idx ON C_site (site_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_parts; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_PARTS' because it does not exist. |
| ij> CREATE TABLE C_parts |
| ( |
| p_id char(15) not null, |
| p_name char(10), |
| p_desc varchar(100), |
| p_rev char(6), |
| p_unit char(10), |
| p_cost numeric(9,2), |
| p_price numeric(9,2), |
| p_planner integer, |
| p_type integer, |
| p_ind integer, |
| p_lomark integer, |
| p_himark integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_p_idx ON C_parts (p_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_rule; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_RULE' because it does not exist. |
| ij> CREATE TABLE C_rule |
| ( |
| r_id varchar(20) not null, |
| r_text long varchar |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_r_idx on C_rule (r_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_discount; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_DISCOUNT' because it does not exist. |
| ij> CREATE TABLE C_discount |
| ( |
| d_id varchar(64) not null, |
| d_percent integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX C_d_idx on C_discount (d_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_parts; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_PARTS' because it does not exist. |
| ij> CREATE TABLE M_parts |
| ( |
| p_id char(15) not null, |
| p_name char(10), |
| p_desc varchar(100), |
| p_rev char(6), |
| p_planner integer, |
| p_type integer, |
| p_ind integer, |
| p_lomark integer, |
| p_himark integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_parts_idx ON M_parts (p_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_bom; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_BOM' because it does not exist. |
| ij> CREATE TABLE M_bom |
| ( |
| b_comp_id char(15) not null, |
| b_assembly_id char(15) not null, |
| b_line_no integer, |
| b_qty integer, |
| b_ops integer, |
| b_eng_change char(10), |
| b_ops_desc varchar(100) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_bom_idx ON M_bom (b_assembly_id, b_comp_id, b_line_no); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_workorder; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_WORKORDER' because it does not exist. |
| ij> CREATE TABLE M_workorder |
| ( |
| wo_number integer not null, |
| wo_o_id integer, |
| wo_ol_id integer, |
| wo_status integer, |
| wo_assembly_id char(15), |
| wo_orig_qty integer, |
| wo_comp_qty integer, |
| wo_due_date date, |
| wo_start_date timestamp |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_wo_idx ON M_workorder (wo_number); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_largeorder; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_LARGEORDER' because it does not exist. |
| ij> CREATE TABLE M_largeorder |
| ( |
| lo_id integer not null, |
| lo_o_id integer, |
| lo_ol_id integer, |
| lo_assembly_id char(15), |
| lo_qty integer, |
| lo_due_date date |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_lo_idx ON M_largeorder (lo_id); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_OL_O_idx ON M_largeorder (lo_o_id, lo_ol_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_inventory; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_INVENTORY' because it does not exist. |
| ij> CREATE TABLE M_inventory |
| ( |
| in_p_id char(15) not null, |
| in_qty integer, |
| in_ordered integer, |
| in_location char(20), |
| in_acc_code integer, |
| in_act_date date |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX M_inv_idx ON M_inventory (in_p_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_customer; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_CUSTOMER' because it does not exist. |
| ij> CREATE TABLE O_customer |
| ( |
| c_id integer not null, |
| c_first char(16), |
| c_last char(16), |
| c_street1 char(20), |
| c_street2 char(20), |
| c_city char(20), |
| c_state char(2), |
| c_country char(10), |
| c_zip char(9), |
| c_phone char(16), |
| c_contact char(25), |
| c_since date |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX O_c_idx ON O_customer (c_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_orders; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_ORDERS' because it does not exist. |
| ij> CREATE TABLE O_orders |
| ( |
| o_id integer not null, |
| o_c_id integer, |
| o_ol_cnt integer, |
| o_discount numeric(4,2), |
| o_total numeric(9,2), |
| o_status integer, |
| o_entry_date timestamp, |
| o_ship_date date |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX O_ords_idx ON O_orders (o_id); |
| 0 rows inserted/updated/deleted |
| ij> CREATE INDEX O_oc_idx ON O_orders (o_c_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_orderline; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_ORDERLINE' because it does not exist. |
| ij> CREATE TABLE O_orderline |
| ( |
| ol_id integer not null, |
| ol_o_id integer not null, |
| ol_i_id char(15), |
| ol_qty integer, |
| ol_status integer, |
| ol_ship_date date |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX O_ordl_idx ON O_orderline (ol_o_id, ol_id); |
| 0 rows inserted/updated/deleted |
| ij> CREATE INDEX O_ordl_idx2 ON O_orderline (ol_o_id, ol_i_id); |
| 0 rows inserted/updated/deleted |
| ij> CREATE INDEX O_ordl_idx3 ON O_orderline (ol_o_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_item; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_ITEM' because it does not exist. |
| ij> CREATE TABLE O_item |
| ( |
| i_id char(15) not null, |
| i_name char(20), |
| i_desc varchar(100), |
| i_price numeric(9,2), |
| i_discount numeric(6,4) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX O_i_idx ON O_item (i_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_component; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_COMPONENT' because it does not exist. |
| ij> CREATE TABLE S_component |
| ( |
| comp_id char(15) not null, |
| comp_name char(10), |
| comp_desc varchar(100), |
| comp_unit char(10), |
| comp_cost numeric(9,2), |
| qty_on_order integer, |
| qty_demanded integer, |
| lead_time integer, |
| container_size integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_comp_idx ON S_component (comp_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_supp_component; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_SUPP_COMPONENT' because it does not exist. |
| ij> CREATE TABLE S_supp_component |
| ( |
| sc_p_id char(15) not null, |
| sc_supp_id integer not null, |
| sc_price numeric(9,2), |
| sc_qty integer, |
| sc_discount numeric(6,4), |
| sc_del_date integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_sc_idx ON S_supp_component (sc_p_id, sc_supp_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_supplier; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_SUPPLIER' because it does not exist. |
| ij> CREATE TABLE S_supplier |
| ( |
| supp_id integer not null, |
| supp_name char(16), |
| supp_street1 char(20), |
| supp_street2 char(20), |
| supp_city char(20), |
| supp_state char(2), |
| supp_country char(10), |
| supp_zip char(9), |
| supp_phone char(16), |
| supp_contact char(25) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_supp_idx ON S_supplier (supp_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_site; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_SITE' because it does not exist. |
| ij> CREATE TABLE S_site |
| ( |
| site_id integer not null, |
| site_name char(16), |
| site_street1 char(20), |
| site_street2 char(20), |
| site_city char(20), |
| site_state char(2), |
| site_country char(10), |
| site_zip char(9) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_site_idx ON S_site (site_id); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_purchase_order; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_PURCHASE_ORDER' because it does not exist. |
| ij> CREATE TABLE S_purchase_order |
| ( |
| po_number integer not null, |
| po_supp_id integer, |
| po_site_id integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_po_idx ON S_purchase_order (po_number); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_purchase_orderline; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'S_PURCHASE_ORDERLINE' because it does not exist. |
| ij> CREATE TABLE S_purchase_orderline |
| ( |
| pol_number integer not null, |
| pol_po_id integer not null, |
| pol_p_id char(15), |
| pol_qty integer, |
| pol_balance numeric(9,2), |
| pol_deldate date, |
| pol_message varchar(100) |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX S_pol_idx ON S_purchase_orderline (pol_po_id, pol_number); |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE U_sequences; |
| ERROR 42Y55: 'DROP TABLE' cannot be performed on 'U_SEQUENCES' because it does not exist. |
| ij> CREATE TABLE U_sequences |
| ( |
| s_id varchar(50) not null, |
| s_nextnum integer, |
| s_blocksize integer |
| ); |
| 0 rows inserted/updated/deleted |
| ij> CREATE UNIQUE INDEX U_s_idx ON U_sequences (s_id); |
| 0 rows inserted/updated/deleted |
| ij> -- set the runtimestatistics to check the query plans generated |
| call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1); |
| 0 rows inserted/updated/deleted |
| ij> maximumdisplaywidth 3500; |
| ij> SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID |
| FROM O_ORDERS T1 WHERE o_c_id = 0 FOR UPDATE ; |
| O_STATUS |O_SHIP_DA&|O_ENTRY_DATE |O_TOTAL |O_DIS&|O_OL_CNT |O_C_ID |O_ID |
| ----------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID |
| FROM O_ORDERS T1 WHERE o_c_id = 0 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERS: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERS using index O_OC_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| qualifiers: |
| None |
| ij> -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT COUNT (*) FROM O_orders WHERE o_entry_date >= '01/10/2003' AND o_entry_date <= '01/09/2003' ; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT COUNT (*) FROM O_orders WHERE o_entry_date >= '01/10/2003' AND o_entry_date <= '01/09/2003' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Table Scan ResultSet for O_ORDERS at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={6} |
| Number of columns fetched=1 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=heap |
| start position: |
| null |
| stop position: |
| null |
| qualifiers: |
| Column[0][0] Id: 6 |
| Operator: < |
| Ordered nulls: false |
| Unknown return value: true |
| Negate comparison result: true |
| Column[0][1] Id: 6 |
| Operator: <= |
| Ordered nulls: false |
| Unknown return value: false |
| Negate comparison result: false |
| ij> SELECT T1.WO_NUMBER, T1.WO_O_ID, T1.WO_OL_ID, T1.WO_STATUS, T1.WO_ORIG_QTY, T1.WO_COMP_QTY, T1.WO_ASSEMBLY_ID, |
| T1.WO_DUE_DATE, T1.WO_START_DATE FROM M_WORKORDER T1 WHERE T1.WO_NUMBER = 1 FOR UPDATE; |
| WO_NUMBER |WO_O_ID |WO_OL_ID |WO_STATUS |WO_ORIG_QTY|WO_COMP_QTY|WO_ASSEMBLY_ID |WO_DUE_DA&|WO_START_DATE |
| -------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.WO_NUMBER, T1.WO_O_ID, T1.WO_OL_ID, T1.WO_STATUS, T1.WO_ORIG_QTY, T1.WO_COMP_QTY, T1.WO_ASSEMBLY_ID, |
| T1.WO_DUE_DATE, T1.WO_START_DATE FROM M_WORKORDER T1 WHERE T1.WO_NUMBER = 1 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_WORKORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_WORKORDER using index M_WO_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT T1.LO_ID, T1.LO_O_ID, T1.LO_OL_ID, T1.LO_ASSEMBLY_ID, T1.LO_QTY, T1.LO_DUE_DATE FROM M_LARGEORDER T1 WHERE 1=1; |
| LO_ID |LO_O_ID |LO_OL_ID |LO_ASSEMBLY_ID |LO_QTY |LO_DUE_DA& |
| -------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT T1.LO_ID, T1.LO_O_ID, T1.LO_OL_ID, T1.LO_ASSEMBLY_ID, T1.LO_QTY, T1.LO_DUE_DATE FROM M_LARGEORDER T1 WHERE 1=1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Table Scan ResultSet for M_LARGEORDER at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=6 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=heap |
| start position: |
| null |
| stop position: |
| null |
| qualifiers: |
| None |
| ij> UPDATE M_INVENTORY SET IN_QTY = 1, IN_LOCATION = 'sanfrancisco', IN_ACC_CODE = 1, IN_ACT_DATE = '01/01/2003', IN_ORDERED = 1 WHERE IN_P_ID = 'abcdefghijklm'; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE M_INVENTORY SET IN_QTY = 1, IN_LOCATION = 'sanfrancisco', IN_ACC_CODE = 1, IN_ACT_DATE = '01/01/2003', IN_ORDERED = 1 WHERE IN_P_ID = 'abcdefghijklm' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_INVENTORY: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_INVENTORY using index M_INV_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM S_component; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM S_component |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for S_COMPONENT using index S_COMP_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.R_ID, T1.R_TEXT FROM C_RULE T1 WHERE T1.R_ID = 'abcdefghijlkmijklmnopqrstuvwxyz'; |
| R_ID |R_TEXT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.R_ID, T1.R_TEXT FROM C_RULE T1 WHERE T1.R_ID = 'abcdefghijlkmijklmnopqrstuvwxyz' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for C_RULE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for C_RULE using index C_R_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM C_site; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM C_site |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for C_SITE using index C_SITE_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.IN_P_ID, T1.IN_QTY, T1.IN_LOCATION, T1.IN_ACC_CODE, T1.IN_ACT_DATE, T1.IN_ORDERED FROM M_INVENTORY T1 WHERE T1.IN_P_ID = 'abcdefghijkl' FOR UPDATE; |
| IN_P_ID |IN_QTY |IN_LOCATION |IN_ACC_CODE|IN_ACT_DA&|IN_ORDERED |
| ----------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.IN_P_ID, T1.IN_QTY, T1.IN_LOCATION, T1.IN_ACC_CODE, T1.IN_ACT_DATE, T1.IN_ORDERED FROM M_INVENTORY T1 WHERE T1.IN_P_ID = 'abcdefghijkl' FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_INVENTORY: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_INVENTORY using index M_INV_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.OL_SHIP_DATE, T1.OL_QTY, T1.OL_I_ID, T1.OL_O_ID, T1.OL_ID FROM O_ORDERLINE T1 WHERE ol_o_id = 1 FOR UPDATE ; |
| OL_SHIP_D&|OL_QTY |OL_I_ID |OL_O_ID |OL_ID |
| -------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.OL_SHIP_DATE, T1.OL_QTY, T1.OL_I_ID, T1.OL_O_ID, T1.OL_ID FROM O_ORDERLINE T1 WHERE ol_o_id = 1 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERLINE using index O_ORDL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> DELETE FROM M_LARGEORDER WHERE LO_ID = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| DELETE FROM M_LARGEORDER WHERE LO_ID = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Delete ResultSet using row locking: |
| deferred: false |
| Rows deleted = 0 |
| Indexes updated = 2 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_LARGEORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_LARGEORDER using index M_LO_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT COUNT (*) FROM M_workorder WHERE wo_start_date >= '01/10/2003' AND wo_start_date <= '01/10/2003'; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT COUNT (*) FROM M_workorder WHERE wo_start_date >= '01/10/2003' AND wo_start_date <= '01/10/2003' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Table Scan ResultSet for M_WORKORDER at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={8} |
| Number of columns fetched=1 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=heap |
| start position: |
| null |
| stop position: |
| null |
| qualifiers: |
| Column[0][0] Id: 8 |
| Operator: <= |
| Ordered nulls: false |
| Unknown return value: false |
| Negate comparison result: false |
| Column[0][1] Id: 8 |
| Operator: < |
| Ordered nulls: false |
| Unknown return value: true |
| Negate comparison result: true |
| ij> SELECT T1.I_DISCOUNT, T1.I_DESC, T1.I_NAME, T1.I_PRICE, T1.I_ID FROM O_ITEM T1 WHERE T1.I_ID = 'abcdefghijk'; |
| I_DISCO&|I_DESC |I_NAME |I_PRICE |I_ID |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.I_DISCOUNT, T1.I_DESC, T1.I_NAME, T1.I_PRICE, T1.I_ID FROM O_ITEM T1 WHERE T1.I_ID = 'abcdefghijk' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ITEM: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ITEM using index O_I_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.P_ID, T1.P_NAME, T1.P_DESC, T1.P_REV, T1.P_PLANNER, T1.P_TYPE, T1.P_IND, T1.P_LOMARK, T1.P_HIMARK FROM M_PARTS T1 WHERE T1.P_ID = 'abcdefghijl'; |
| P_ID |P_NAME |P_DESC |P_REV |P_PLANNER |P_TYPE |P_IND |P_LOMARK |P_HIMARK |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.P_ID, T1.P_NAME, T1.P_DESC, T1.P_REV, T1.P_PLANNER, T1.P_TYPE, T1.P_IND, T1.P_LOMARK, T1.P_HIMARK FROM M_PARTS T1 WHERE T1.P_ID = 'abcdefghijl' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for M_PARTS: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_PARTS using index M_PARTS_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM S_purchase_orderline; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM S_purchase_orderline |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for S_PURCHASE_ORDERLINE using index S_POL_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.S_ID, T1.S_NEXTNUM, T1.S_BLOCKSIZE FROM U_SEQUENCES T1 WHERE T1.S_ID = 'abcdefghijklmnopqrstuvwxyz' FOR UPDATE; |
| S_ID |S_NEXTNUM |S_BLOCKSIZE |
| -------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.S_ID, T1.S_NEXTNUM, T1.S_BLOCKSIZE FROM U_SEQUENCES T1 WHERE T1.S_ID = 'abcdefghijklmnopqrstuvwxyz' FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for U_SEQUENCES: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for U_SEQUENCES using index U_S_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.SC_P_ID, T1.SC_SUPP_ID, T1.SC_PRICE, T1.SC_QTY, T1.SC_DISCOUNT, T1.SC_DEL_DATE FROM S_SUPP_COMPONENT T1 WHERE T1.SC_P_ID = 'abcdefgjikl' AND T1.SC_SUPP_ID = 1; |
| SC_P_ID |SC_SUPP_ID |SC_PRICE |SC_QTY |SC_DISC&|SC_DEL_DATE |
| ------------------------------------------------------------------------ |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.SC_P_ID, T1.SC_SUPP_ID, T1.SC_PRICE, T1.SC_QTY, T1.SC_DISCOUNT, T1.SC_DEL_DATE FROM S_SUPP_COMPONENT T1 WHERE T1.SC_P_ID = 'abcdefgjikl' AND T1.SC_SUPP_ID = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_SUPP_COMPONENT: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {2, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_SUPP_COMPONENT using index S_SC_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| qualifiers: |
| None |
| ij> SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID FROM O_ORDERS T1 WHERE T1.O_ID = 1 FOR UPDATE; |
| O_STATUS |O_SHIP_DA&|O_ENTRY_DATE |O_TOTAL |O_DIS&|O_OL_CNT |O_C_ID |O_ID |
| ----------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.O_STATUS, T1.O_SHIP_DATE, T1.O_ENTRY_DATE, T1.O_TOTAL, T1.O_DISCOUNT, T1.O_OL_CNT, T1.O_C_ID, T1.O_ID FROM O_ORDERS T1 WHERE T1.O_ID = 1 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERS: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERS using index O_ORDS_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM M_workorder; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM M_workorder |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for M_WORKORDER using index M_WO_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM S_purchase_order; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM S_purchase_order |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for S_PURCHASE_ORDER using index S_PO_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM M_bom; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM M_bom |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for M_BOM using index M_BOM_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.PO_NUMBER, T1.PO_SUPP_ID, T1.PO_SITE_ID FROM S_PURCHASE_ORDER T1 WHERE T1.PO_NUMBER = 1; |
| PO_NUMBER |PO_SUPP_ID |PO_SITE_ID |
| ----------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.PO_NUMBER, T1.PO_SUPP_ID, T1.PO_SITE_ID FROM S_PURCHASE_ORDER T1 WHERE T1.PO_NUMBER = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_PURCHASE_ORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_PURCHASE_ORDER using index S_PO_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM O_orderline; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM O_orderline |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for O_ORDERLINE using index O_ORDL_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.D_ID, T1.D_PERCENT FROM C_DISCOUNT T1 WHERE T1.D_ID = 'abcdefghijklmnopqrstuvwz'; |
| D_ID |D_PERCENT |
| ---------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.D_ID, T1.D_PERCENT FROM C_DISCOUNT T1 WHERE T1.D_ID = 'abcdefghijklmnopqrstuvwz' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for C_DISCOUNT: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for C_DISCOUNT using index C_D_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> UPDATE O_ORDERLINE SET OL_SHIP_DATE = '2/28/2000', OL_QTY = 10, OL_I_ID = 'abcdefghijkl' WHERE OL_O_ID = 1 AND OL_ID = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE O_ORDERLINE SET OL_SHIP_DATE = '2/28/2000', OL_QTY = 10, OL_I_ID = 'abcdefghijkl' WHERE OL_O_ID = 1 AND OL_ID = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 1 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {2, 3, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERLINE using index O_ORDL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| qualifiers: |
| None |
| ij> SELECT T1.COMP_ID, T1.COMP_NAME, T1.COMP_DESC, T1.COMP_UNIT, T1.COMP_COST, T1.QTY_ON_ORDER, T1.QTY_DEMANDED, T1.LEAD_TIME, T1.CONTAINER_SIZE FROM S_COMPONENT T1 WHERE T1.COMP_ID = 'abcdefghijk' FOR UPDATE; |
| COMP_ID |COMP_NAME |COMP_DESC |COMP_UNIT |COMP_COST |QTY_ON_ORD&|QTY_DEMAND&|LEAD_TIME |CONTAINER_& |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.COMP_ID, T1.COMP_NAME, T1.COMP_DESC, T1.COMP_UNIT, T1.COMP_COST, T1.QTY_ON_ORDER, T1.QTY_DEMANDED, T1.LEAD_TIME, T1.CONTAINER_SIZE FROM S_COMPONENT T1 WHERE T1.COMP_ID = 'abcdefghijk' FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_COMPONENT: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6, 7, 8} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_COMPONENT using index S_COMP_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM O_customer; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM O_customer |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for O_CUSTOMER using index O_C_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.LO_ID, T1.LO_O_ID, T1.LO_OL_ID, T1.LO_ASSEMBLY_ID, T1.LO_QTY, T1.LO_DUE_DATE FROM M_LARGEORDER T1 WHERE lo_o_id = 1 AND lo_ol_id = 1; |
| LO_ID |LO_O_ID |LO_OL_ID |LO_ASSEMBLY_ID |LO_QTY |LO_DUE_DA& |
| -------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.LO_ID, T1.LO_O_ID, T1.LO_OL_ID, T1.LO_ASSEMBLY_ID, T1.LO_QTY, T1.LO_DUE_DATE FROM M_LARGEORDER T1 WHERE lo_o_id = 1 AND lo_ol_id = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for M_LARGEORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_LARGEORDER using index M_OL_O_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| qualifiers: |
| None |
| ij> UPDATE O_ORDERS SET O_STATUS = 1, O_SHIP_DATE = '01/01/9004', O_ENTRY_DATE = NULL, O_TOTAL = 1000, O_DISCOUNT =100, O_OL_CNT = 1, O_C_ID = 1 WHERE O_ID = 2; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE O_ORDERS SET O_STATUS = 1, O_SHIP_DATE = '01/01/9004', O_ENTRY_DATE = NULL, O_TOTAL = 1000, O_DISCOUNT =100, O_OL_CNT = 1, O_C_ID = 1 WHERE O_ID = 2 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 1 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERS: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERS using index O_ORDS_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM C_customer; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM C_customer |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for C_CUSTOMER using index C_C_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM M_inventory; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM M_inventory |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for M_INVENTORY using index M_INV_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT T1.SUPP_ID, T1.SUPP_NAME, T1.SUPP_STREET1, T1.SUPP_STREET2, T1.SUPP_CITY, T1.SUPP_STATE, T1.SUPP_COUNTRY, T1.SUPP_ZIP, T1.SUPP_PHONE, T1.SUPP_CONTACT FROM S_SUPPLIER T1 WHERE 1=1; |
| SUPP_ID |SUPP_NAME |SUPP_STREET1 |SUPP_STREET2 |SUPP_CITY |SUP&|SUPP_COUN&|SUPP_ZIP |SUPP_PHONE |SUPP_CONTACT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- MAKE SURE THE FOLLOWING USE TABLE SCAN, NO REASON TO USE INDEX AT ALL, NOT USEFUL PREDICATES!!! |
| SELECT T1.SUPP_ID, T1.SUPP_NAME, T1.SUPP_STREET1, T1.SUPP_STREET2, T1.SUPP_CITY, T1.SUPP_STATE, T1.SUPP_COUNTRY, T1.SUPP_ZIP, T1.SUPP_PHONE, T1.SUPP_CONTACT FROM S_SUPPLIER T1 WHERE 1=1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Table Scan ResultSet for S_SUPPLIER at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=10 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=heap |
| start position: |
| null |
| stop position: |
| null |
| qualifiers: |
| None |
| ij> UPDATE U_SEQUENCES SET S_NEXTNUM = 1 , S_BLOCKSIZE = 1000 WHERE S_ID = 'abcdefghijklmnopqrstuvwxyz'; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE U_SEQUENCES SET S_NEXTNUM = 1 , S_BLOCKSIZE = 1000 WHERE S_ID = 'abcdefghijklmnopqrstuvwxyz' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for U_SEQUENCES: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for U_SEQUENCES using index U_S_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM M_parts ; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM M_parts |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for M_PARTS using index M_PARTS_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM O_item; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM O_item |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for O_ITEM using index O_I_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> UPDATE M_WORKORDER SET WO_O_ID = 11, WO_OL_ID = 11, WO_STATUS = 11, WO_ORIG_QTY = 11, WO_COMP_QTY = 11, WO_ASSEMBLY_ID = 'abcdefghijk', WO_DUE_DATE = '01/01/2000', WO_START_DATE = '01/01/00' WHERE WO_NUMBER = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE M_WORKORDER SET WO_O_ID = 11, WO_OL_ID = 11, WO_STATUS = 11, WO_ORIG_QTY = 11, WO_COMP_QTY = 11, WO_ASSEMBLY_ID = 'abcdefghijk', WO_DUE_DATE = '01/01/2000', WO_START_DATE = '01/01/00' WHERE WO_NUMBER = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_WORKORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_WORKORDER using index M_WO_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE T1 WHERE T1.POL_NUMBER = 100 AND T1.POL_PO_ID = 200 FOR UPDATE; |
| POL_NUMBER |POL_PO_ID |POL_P_ID |POL_QTY |POL_BALANCE|POL_DELDA&|POL_MESSAGE |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE T1 WHERE T1.POL_NUMBER = 100 AND T1.POL_PO_ID = 200 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_PURCHASE_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_PURCHASE_ORDERLINE using index S_POL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| qualifiers: |
| None |
| ij> SELECT T1.OL_SHIP_DATE, T1.OL_QTY, T1.OL_I_ID, T1.OL_O_ID, T1.OL_ID FROM O_ORDERLINE T1 WHERE ol_o_id = 100 AND ol_i_id = 'abcdefgh' FOR UPDATE; |
| OL_SHIP_D&|OL_QTY |OL_I_ID |OL_O_ID |OL_ID |
| -------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.OL_SHIP_DATE, T1.OL_QTY, T1.OL_I_ID, T1.OL_O_ID, T1.OL_ID FROM O_ORDERLINE T1 WHERE ol_o_id = 100 AND ol_i_id = 'abcdefgh' FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = true |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERLINE using index O_ORDL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE T1 WHERE pol_po_id = 11 FOR UPDATE; |
| POL_NUMBER |POL_PO_ID |POL_P_ID |POL_QTY |POL_BALANCE|POL_DELDA&|POL_MESSAGE |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.POL_NUMBER, T1.POL_PO_ID, T1.POL_P_ID, T1.POL_QTY, T1.POL_BALANCE, T1.POL_DELDATE, T1.POL_MESSAGE FROM S_PURCHASE_ORDERLINE T1 WHERE pol_po_id = 11 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_PURCHASE_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_PURCHASE_ORDERLINE using index S_POL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> DELETE FROM O_ORDERS WHERE O_ID = 1; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| DELETE FROM O_ORDERS WHERE O_ID = 1 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Delete ResultSet using row locking: |
| deferred: false |
| Rows deleted = 0 |
| Indexes updated = 2 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERS: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERS using index O_ORDS_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM O_orders; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM O_orders |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for O_ORDERS using index O_ORDS_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM S_supplier; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM S_supplier |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for S_SUPPLIER using index S_SUPP_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.C_ID, T1.C_SINCE, T1.C_BALANCE, T1.C_CREDIT, T1.C_CREDIT_LIMIT, T1.C_YTD_PAYMENT FROM C_CUSTOMER T1 WHERE T1.C_ID = 1111 FOR UPDATE; |
| C_ID |C_SINCE |C_BALANCE |C_C&|C_CREDIT_L&|C_YTD_PAYM& |
| --------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.C_ID, T1.C_SINCE, T1.C_BALANCE, T1.C_CREDIT, T1.C_CREDIT_LIMIT, T1.C_YTD_PAYMENT FROM C_CUSTOMER T1 WHERE T1.C_ID = 1111 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for C_CUSTOMER: |
| 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 C_CUSTOMER using index C_C_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> -- MAKE SURE THE FOLLOWING DELETE STATEMENT USES UNIQUE INDEX "O_ORDL_IDX", NOT NON-UNIQUE INDEX "O_ORDL_IDX2", |
| -- EVEN THOUGH WE ARE COMPILING WITH EMPTY TABLE!!! beetle 5006. |
| DELETE FROM O_ORDERLINE WHERE OL_O_ID = 11111 AND OL_ID = 111111; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| -- MAKE SURE THE FOLLOWING DELETE STATEMENT USES UNIQUE INDEX "O_ORDL_IDX", NOT NON-UNIQUE INDEX "O_ORDL_IDX2", |
| -- EVEN THOUGH WE ARE COMPILING WITH EMPTY TABLE!!! beetle 5006. |
| DELETE FROM O_ORDERLINE WHERE OL_O_ID = 11111 AND OL_ID = 111111 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Delete ResultSet using row locking: |
| deferred: false |
| Rows deleted = 0 |
| Indexes updated = 3 |
| Execute Time = 0 |
| Project-Restrict ResultSet (2): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_ORDERLINE using index O_ORDL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM C_supplier; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM C_supplier |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for C_SUPPLIER using index C_SUPP_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.B_ASSEMBLY_ID, T1.B_COMP_ID, T1.B_LINE_NO, T1.B_QTY, T1.B_ENG_CHANGE, T1.B_OPS, T1.B_OPS_DESC FROM M_BOM T1 WHERE b_assembly_id = 'specjstuff'; |
| B_ASSEMBLY_ID |B_COMP_ID |B_LINE_NO |B_QTY |B_ENG_CHA&|B_OPS |B_OPS_DESC |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.B_ASSEMBLY_ID, T1.B_COMP_ID, T1.B_LINE_NO, T1.B_QTY, T1.B_ENG_CHANGE, T1.B_OPS, T1.B_OPS_DESC FROM M_BOM T1 WHERE b_assembly_id = 'specjstuff' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for M_BOM: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2, 3, 4, 5, 6} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for M_BOM using index M_BOM_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={0, 3} |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> UPDATE S_COMPONENT SET COMP_NAME = 'abc', COMP_DESC = 'book', COMP_UNIT = '100', COMP_COST = 1000, QTY_ON_ORDER = 1000, QTY_DEMANDED = 111, LEAD_TIME = 11, CONTAINER_SIZE = 11 WHERE COMP_ID = 'rudyardkipling'; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE S_COMPONENT SET COMP_NAME = 'abc', COMP_DESC = 'book', COMP_UNIT = '100', COMP_COST = 1000, QTY_ON_ORDER = 1000, QTY_DEMANDED = 111, LEAD_TIME = 11, CONTAINER_SIZE = 11 WHERE COMP_ID = 'rudyardkipling' |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for S_COMPONENT: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_COMPONENT using index S_COMP_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT T1.PO_NUMBER, T1.PO_SUPP_ID, T1.PO_SITE_ID FROM S_PURCHASE_ORDER T1 WHERE T1.PO_NUMBER = 100 FOR UPDATE; |
| PO_NUMBER |PO_SUPP_ID |PO_SITE_ID |
| ----------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.PO_NUMBER, T1.PO_SUPP_ID, T1.PO_SITE_ID FROM S_PURCHASE_ORDER T1 WHERE T1.PO_NUMBER = 100 FOR UPDATE |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Index Row to Base Row ResultSet for S_PURCHASE_ORDER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {0, 1, 2} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_PURCHASE_ORDER using index S_PO_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> UPDATE S_PURCHASE_ORDERLINE SET POL_P_ID = 'teacup', POL_QTY = 2, POL_BALANCE = 2, POL_DELDATE = '01/01/2000', POL_MESSAGE = 'tintin shooting star' WHERE POL_NUMBER = 1 AND POL_PO_ID = 1111; |
| 0 rows inserted/updated/deleted |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| UPDATE S_PURCHASE_ORDERLINE SET POL_P_ID = 'teacup', POL_QTY = 2, POL_BALANCE = 2, POL_DELDATE = '01/01/2000', POL_MESSAGE = 'tintin shooting star' WHERE POL_NUMBER = 1 AND POL_PO_ID = 1111 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Update ResultSet using row locking: |
| deferred: false |
| Rows updated = 0 |
| Indexes updated = 0 |
| Execute Time = 0 |
| Normalize ResultSet: |
| Number of opens = 1 |
| Rows seen = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for S_PURCHASE_ORDERLINE: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {2, 3, 4, 5, 6} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for S_PURCHASE_ORDERLINE using index S_POL_IDX at read committed isolation level using exclusive row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 1 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=3 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| stop position: |
| > on first 2 column(s). |
| Ordered null semantics on the following columns: |
| 0 1 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM S_site ; |
| 1 |
| ----------- |
| 0 |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT COUNT (*) FROM S_site |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (4): |
| Number of opens = 1 |
| Rows seen = 1 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Scalar Aggregate ResultSet: |
| Number of opens = 1 |
| Rows input = 0 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Key Optimization = false |
| Source result set: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Scan ResultSet for S_SITE using index S_SITE_IDX at read committed isolation level using instantaneous share row locking chosen by the optimizer |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| Fetch Size = 16 |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched={} |
| Number of columns fetched=0 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| None |
| stop position: |
| None |
| qualifiers: |
| None |
| ij> SELECT T1.C_SINCE, T1.C_STREET1, T1.C_STREET2, T1.C_CITY, T1.C_STATE, T1.C_COUNTRY, T1.C_ZIP, T1.C_PHONE, T1.C_CONTACT, T1.C_LAST, T1.C_FIRST, T1.C_ID FROM O_CUSTOMER T1 WHERE T1.C_ID = 23456; |
| C_SINCE |C_STREET1 |C_STREET2 |C_CITY |C_S&|C_COUNTRY |C_ZIP |C_PHONE |C_CONTACT |C_LAST |C_FIRST |C_ID |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); |
| 1 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Statement Name: |
| null |
| Statement Text: |
| SELECT T1.C_SINCE, T1.C_STREET1, T1.C_STREET2, T1.C_CITY, T1.C_STATE, T1.C_COUNTRY, T1.C_ZIP, T1.C_PHONE, T1.C_CONTACT, T1.C_LAST, T1.C_FIRST, T1.C_ID FROM O_CUSTOMER T1 WHERE T1.C_ID = 23456 |
| Parse Time: 0 |
| Bind Time: 0 |
| Optimize Time: 0 |
| Generate Time: 0 |
| Compile Time: 0 |
| Execute Time: 0 |
| Begin Compilation Timestamp : null |
| End Compilation Timestamp : null |
| Begin Execution Timestamp : null |
| End Execution Timestamp : null |
| Statement Execution Plan Text: |
| Project-Restrict ResultSet (3): |
| Number of opens = 1 |
| Rows seen = 0 |
| Rows filtered = 0 |
| restriction = false |
| projection = true |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| restriction time (milliseconds) = 0 |
| projection time (milliseconds) = 0 |
| Source result set: |
| Index Row to Base Row ResultSet for O_CUSTOMER: |
| Number of opens = 1 |
| Rows seen = 0 |
| Columns accessed from heap = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11} |
| constructor time (milliseconds) = 0 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| Index Scan ResultSet for O_CUSTOMER using index O_C_IDX at read committed 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 |
| open time (milliseconds) = 0 |
| next time (milliseconds) = 0 |
| close time (milliseconds) = 0 |
| scan information: |
| Bit set of columns fetched=All |
| Number of columns fetched=2 |
| Number of deleted rows visited=0 |
| Number of pages visited=1 |
| Number of rows qualified=0 |
| Number of rows visited=0 |
| Scan type=btree |
| Tree height=1 |
| start position: |
| >= on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| stop position: |
| > on first 1 column(s). |
| Ordered null semantics on the following columns: |
| 0 |
| qualifiers: |
| None |
| ij> SELECT COUNT (*) FROM C_parts; |
| 1 |
| ----------- |
| 0 |
| ij> INSERT INTO O_ORDERLINE (OL_O_ID, OL_ID, OL_SHIP_DATE, OL_QTY, OL_I_ID) VALUES (1, 1,NULL, 1,'abcdefghijklmn') ; |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO M_LARGEORDER (LO_ID, LO_O_ID, LO_OL_ID, LO_ASSEMBLY_ID, LO_QTY, LO_DUE_DATE) VALUES (2, 2, 2,'id', 2, date('2000-02-29')); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO O_ORDERS (O_ID, O_STATUS, O_SHIP_DATE, O_ENTRY_DATE, O_TOTAL, O_DISCOUNT, O_OL_CNT, O_C_ID) VALUES (111, 11, date('1999-01-01'),timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx), 10, 10, 10, 10); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO M_WORKORDER (WO_NUMBER, WO_O_ID, WO_OL_ID, WO_STATUS, WO_ORIG_QTY, WO_COMP_QTY, WO_ASSEMBLY_ID, WO_DUE_DATE, WO_START_DATE) VALUES (10,10 ,10, 10,10, 10, 'abcd', date('2099-10-10'), timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx)); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO O_CUSTOMER (C_ID, C_SINCE, C_STREET1, C_STREET2, C_CITY, C_STATE, C_COUNTRY, C_ZIP, C_PHONE, C_CONTACT, C_LAST, C_FIRST) VALUES (1, date('2000-01-01'), 'berkeley', 'berkeley','berkeley','ca', 'usofa', '94703', '01191797897', 'calvinandhobbes', 'watterson','bill'); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO S_PURCHASE_ORDER (PO_NUMBER, PO_SUPP_ID, PO_SITE_ID) VALUES (100, 100, 100); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO S_PURCHASE_ORDERLINE (POL_NUMBER, POL_PO_ID, POL_P_ID, POL_QTY, POL_BALANCE, POL_DELDATE, POL_MESSAGE) VALUES (121,987 ,'snowsnowsnow',11 , 999, date('2003-1-01'),'wow, it really snowed last night isnt it wonderful last calvin and hobbes'); |
| 1 row inserted/updated/deleted |
| ij> INSERT INTO C_CUSTOMER (C_ID, C_SINCE, C_BALANCE, C_CREDIT, C_CREDIT_LIMIT, C_YTD_PAYMENT) VALUES (11, date('2000-10-01'), 1000, 'ab', 10000,1000.20); |
| 1 row inserted/updated/deleted |
| ij> -- Cleanup : Drop all the tables created as part of this test |
| DROP TABLE C_customer; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_supplier; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_site; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_parts; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_rule; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE C_discount; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_parts; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_bom; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_workorder; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_largeorder; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE M_inventory; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_customer; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_orders; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_orderline; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE O_item; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_component; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_supp_component; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_supplier; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_site; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_purchase_order; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE S_purchase_orderline; |
| 0 rows inserted/updated/deleted |
| ij> DROP TABLE U_sequences; |
| 0 rows inserted/updated/deleted |
| ij> |
