| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Explain plan...
Hi.
I have two SQL statements:
1.
select 1,gco_code,gan_code,sum(remain_amt)
from vad_otvp_pol_view
where gan_code='31101' and gco_code='076'
and gan_gcn_code='ZOS'
group by gco_code,gan_code;
2.
insert into ad_check_saldo (code,gco_code,gan_code,remain_amt)
select 1,gco_code,gan_code,sum(remain_amt)
from vad_otvp_pol_view
where gan_code='31101' and gco_code='076'
and gan_gcn_code='ZOS'
group by gco_code,gan_code;
The first one works fine and return one row. The second one inserts one row (with select above) into small empty table without constraints and works very long.
Can someone help me? (Please, see TKPROF output in attachment and compare lines with RDS_GAN_FK_I in SELECT and then in INSERT statement) Answers please on prak_at_vsz.sk
Peter Rak
VSZ Kosice
Slovak Republic
TKPROF: Release 7.3.2.2.0 - Production on Fri Sep 11 13:15:23 1998
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Trace file: ora_87438.trc
Sort options: default
count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ********************************************************************************
select 1,gco_code,gan_code,sum(remain_amt)
from vad_otvp_pol_view
where gan_code='31101' and gco_code='076'
and gan_gcn_code='ZOS'
group by gco_code,gan_code
call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 9.69 9.68 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.24 0.20 0 1146 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 9.93 9.88 0 1146 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 8 (STEEL)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
30 SORT (GROUP BY)
30 VIEW OF 'VAD_SALDO_HIST'
30 UNION-ALL
0 VIEW OF 'VAP_SALDO_HIST'
0 UNION-ALL
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
1 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
1 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OPL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PVC_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
1 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'PVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
25 VIEW OF 'VAR_SALDO_HIST'
25 UNION-ALL
25 FILTER
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
32 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
32 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_DIST'
33 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'RDS_GAN_FK_I' (NON-UNIQUE)
32 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
32 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
25 NESTED LOOPS
32 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
32 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_DIST'
33 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'RDS_GAN_FK_I' (NON-UNIQUE)
32 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
32 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'RVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
5 VIEW OF 'VBA_SALDO_HIST'
5 UNION-ALL
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
13 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OPL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BA_CHEQUE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'FCQ_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'BVG_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'BVC_PK'
(UNIQUE)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
13 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BA_CHEQUE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
12 NESTED LOOPS
12 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
13 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
12 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'AP_VOUCHER'
12 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
12 NESTED LOOPS
12 NESTED LOOPS
1 NESTED LOOPS
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
1 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
13 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
12 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
12 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'AR_VOUCHER'
12 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
********************************************************************************
insert into ad_check_saldo (code,gco_code,gan_code,remain_amt)
select 1,gco_code,gan_code,sum(remain_amt)
from vad_otvp_pol_view
where gan_code='31101' and gco_code='076'
and gan_gcn_code='ZOS'
group by gco_code,gan_code
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 9.09 9.03 0 0 0 0
Execute 1 101.99 116.90 16909 1370754 3 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 111.08 125.93 16909 1370754 3 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 8 (STEEL)
Rows Execution Plan
------- ---------------------------------------------------
0 INSERT STATEMENT GOAL: CHOOSE
30 SORT (GROUP BY)
30 VIEW OF 'VAD_SALDO_HIST'
30 UNION-ALL
0 VIEW OF 'VAP_SALDO_HIST'
0 UNION-ALL
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
0 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
0 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OPL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PVC_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
1 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_DIST'
0 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'PDS_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'PVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
25 VIEW OF 'VAR_SALDO_HIST'
25 UNION-ALL
25 FILTER
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
25 NESTED LOOPS
36374 NESTED LOOPS
36374 NESTED LOOPS
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
36375 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
36374 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_DIST'
36374 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'RDS_GAN_FK_I' (NON-UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
36374 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
25 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
25 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 FILTER
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
4537 NESTED LOOPS
36374 NESTED LOOPS
36374 NESTED LOOPS
36374 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_ACCOUNT'
36375 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED
(BY ROWID) OF 'GL_COMPANY'
36374 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_DIST'
36374 INDEX GOAL: ANALYZED (RANGE
SCAN) OF 'RDS_GAN_FK_I' (NON-UNIQUE)
36374 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
36374 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'RVC_PK' (UNIQUE)
77 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'AR_VOUCHER'
4537 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
5 VIEW OF 'VBA_SALDO_HIST'
5 UNION-ALL
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
15 NESTED LOOPS
15 NESTED LOOPS
48443 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
48444 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
15 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
15 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
15 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
15 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
3 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
15 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'OTR_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'OPL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BA_CHEQUE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'FCQ_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'BVG_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'BVC_PK'
(UNIQUE)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
690 NESTED LOOPS
690 NESTED LOOPS
690 NESTED LOOPS
690 NESTED LOOPS
48443 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
48444 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
690 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
690 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
690 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
690 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
690 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'BA_CHEQUE'
690 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
690 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
690 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
690 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
690 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
0 NESTED LOOPS
48443 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
48444 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
43094 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
0 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'AP_VOUCHER'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'PVC_PK' (UNIQUE)
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
5 NESTED LOOPS
48443 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_ACCOUNT'
48444 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GAN_PK' (UNIQUE)
43094 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'GL_COMPANY'
43094 INDEX GOAL: ANALYZED (UNIQUE
SCAN) OF 'GCO_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHQDIST'
5 INDEX GOAL: ANALYZED (RANGE SCAN)
OF 'FCD_GAN_FK_I' (NON-UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY
ROWID) OF 'BA_CHEQUE'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'FCQ_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID)
OF 'AR_VOUCHER'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN)
OF 'RVC_PK' (UNIQUE)
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BFA_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST_ALL'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVL_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VENGROUP'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVG_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'BP_VEND_CUST'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'BVC_PK' (UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_TRANS'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OTR_PK'
(UNIQUE)
5 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'OP_PLACE'
5 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'OPL_PK'
(UNIQUE)
********************************************************************************
ALTER SESSION SET SQL_TRACE=FALSE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.01 0 0 0 0
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 8 (STEEL)
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 18.80 18.72 0 0 0 0 Execute 7 102.02 117.00 16909 1370755 6 1 Fetch 4 0.24 0.20 0 1146 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 121.06 135.92 16909 1371901 6 10
Misses in library cache during parse: 3 Misses in library cache during execute: 1
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 26 0.02 0.07 0 0 0 0 Execute 412 0.32 0.44 0 240 0 340 Fetch 182 0.11 0.05 0 864 0 122 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 620 0.45 0.56 0 1104 0 462
Misses in library cache during parse: 0
24 user SQL statements in session.
12 internal SQL statements in session.
36 SQL statements in session.
5 statements EXPLAINed in this session.
0 session in tracefile.
24 user SQL statements in trace file.
12 internal SQL statements in trace file.
36 SQL statements in trace file.
15 unique SQL statements in trace file.
5 SQL statements EXPLAINed using schema:
STEEL.prof$plan_table
Default table was used.
Table was created.
Table was dropped.
 |
 |