1

tbsql TIBERO/TMAX

CONNECTED TO TIBERO.

CREATE TABLE PLAN_TEST(C1 NUMBER,C2 NUMBER, C3 NUMBER);
TABLE 'PLAN_TEST' CREATED.

declare
begin

for i in 1..10000 loop

insert into plan_test values(i,i,i);
end loop;

end;

/

PSM completed.

SQL> COMMIT;

Commit completed.
 

CREATE INDEX PLAN_TEST_IDX ON PLAN_TEST(C1);

Index 'PLAN_TEST_IDX' created.

SET LINES 200

SET AUTOT TRACEONLY EXP PLANSTAT

select * from plan_test where c1 between 10 and 100;

SQL ID: 63qt2v8qbnum4
Child number: 326
Plan hash value: 3347569165

Execution Plan
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1  TABLE ACCESS (ROWID): PLAN_TEST (Cost:3, %%CPU:0, Rows:99)
  2    INDEX (RANGE SCAN): PLAN_TEST_IDX (Cost:2, %%CPU:0, Rows:99)

Execution Stat
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1  TABLE ACCESS (ROWID): PLAN_TEST (Time:1.11 ms, Rows:91, Starts:1)
  2    INDEX (RANGE SCAN): PLAN_TEST_IDX (Time:.19 ms, Rows:91, Starts:1)

Predicate Information
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2 - access: ("PLAN_TEST"."C1" >= 10) AND ("PLAN_TEST"."C1" <= 100) (0.999 * 0.008)

Note
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2 - dynamic sampling used for this table (44 blocks)

select * from plan_test where c1 between 10 and 100;

       C1         C2         C3
---------- ---------- ----------
       10         10         10
       11         11         11
       12         12         12
... (results omitted)

exit
Disconnected.

cd $TB_HOME/instance/$TB_SID/log/sqltrace

tbprof tb_sqltrc_2939_120_12145.trc result_trqce.log
 

vi result_trqce.log

TBPROF 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

input file name : tb_sqltrc_2939_120_12145.trc
output file name : result_trqce.log
sort option : default
aggregate : yes
sys : yes
print : all

=================================================================
count: number of times the procedure was executed
cpu: cpu time(seconds)
     this is not quite accurate due to threaded architecture
...(omitted)