tkprof tuning

Kelly / List

How can the Figure query = 5265803 be reduced in the following tkprof ?

Any Good Docs on tkprof ?

> select count(*) ,TO_CHAR(sum(DECODE(DR_CR_IND,'D',TRAN_AMT,'C',(TRAN_AMT*
>
> (-1))))) into :b0,:b1
> from
> IRT where (((((RESP_EXTN_CNTR_CODE=:b2 and RESP_BR_CODE=:b3) and
> RESP_BANK_CODE=:b4) and RESP_DATE=TO_DATE(:b5,'DD-MM-YYYY HH24:MI:SS'))
> and
> IBA_NUM=:b6) and MATCHED_FLG='N')
>
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 749 0.33 0.31 0 0 0
> 0
> Execute 749 0.14 0.11 0 0 0
> 0
> Fetch 749 91.06 91.36 3337 5265803 0
> 746
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 2247 91.53 91.78 3337 5265803 0
> 746
>
> Misses in library cache during parse: 1
> Optimizer goal: CHOOSE
> Parsing user id: 10 (TBAGEN)
>
> Rows Execution Plan
> ------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 1 SORT (AGGREGATE)
> 6564 TABLE ACCESS (BY ROWID) OF 'INTER_BR_RESP_TRAN_TABLE'
> 6565 INDEX (RANGE SCAN) OF 'IDX_IRT_MATCHED_FLG' (NON-UNIQUE)PLEASE
Received on Fri Aug 04 2000 - 01:31:22 CDT