select dat_real_fee_id, charge
from
dat_real_fee_557_201004 where prd_inst_id =:v1 and ofr_id =:v2 and
acct_item_type_id =:v3 and event_pricing_strategy_id =:v4 and pay_flag =:v5
and fee_type =:v6 and source_inst_id = :v7
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.01 0.00 0 0 0 0
Execute 22822 0.31 0.31 0 0 0 0
Fetch 22822 11.50 28.48 1401 1814936 0 22777
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 45647 11.82 28.80 1401 1814936 0 22777
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 33
Rows Row Source Operation
------- ---------------------------------------------------
9216 TABLE ACCESS BY INDEX ROWID DAT_REAL_FEE_557_201004 (cr=106002 pr=410 pw=0 time=5193912 us)
128896 INDEX RANGE SCAN DAT_REAL_FEE_557_201004_03 (cr=28044 pr=223 pw=0 time=2925985 us)(object id 374919)
类似于这样的一个执行计划,统计信息的
Row 1 Fields
OWNER IBA3
TABLE_NAME DAT_REAL_FEE_551_201004
TABLESPACE_NAME IBA3_TBS_CALL3
CLUSTER_NAME
IOT_NAME
STATUS VALID
PCT_FREE 10
PCT_USED
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING YES
BACKED_UP N
NUM_ROWS 14247424
BLOCKS 134799
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 63
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 3561856
LAST_ANALYZED 2010-4-16 6:04
PARTITIONED NO
IOT_TYPE
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER
DEPENDENCIES DISABLED
COMPRESSION DISABLED
DROPPED NO