- 论坛徽章:
- 0
|
5可用积分
select to_char(e.so_region_code),
to_char(e.so_county_code),
to_char(e.so_nbr),
to_char(a.phone_id),
to_char(b.promo_id),
to_char(b.cond_id),
to_char(b.act_type),
to_char(b.valid_date, 'yyyy-mm-dd hh24:mi:ss'),
to_char(b.expire_date, 'yyyy-mm-dd hh24:mi:ss'),
to_char(c.book_item_id),
to_char(c.item_total / 100.00)
from zk.cm_user a,
zk.cm_busi_promo b,
zk.cm_busi_charge_200810 c,
xg.sys_organizations d,
zk.cm_busi_200810 e
where e.so_org_id = d.org_id
and e.so_nbr = c.so_nbr
and b.so_nbr = c.so_nbr
and a.serv_id = e.serv_id
and e.process_id <> 4
and e.PROCESS_RESULT = 2
and c.oper_type <> 5
and e.so_date >= to_date('2008100100000', 'yyyymmddhh24miss')
and e.so_date <= to_date('20081031235959', 'yyyymmddhh24miss')
and e.so_county_code in (917)
group by e.so_region_code,
e.so_county_code,
e.so_nbr,
a.phone_id,
b.promo_id,
b.cond_id,
b.act_type,
b.valid_date,
b.expire_date,
c.book_item_id,
c.item_total
SELECT STATEMENT, GOAL = CHOOSE 24000 1 154
SORT GROUP BY 24000 1 154
NESTED LOOPS 23998 1 154
NESTED LOOPS 23996 1 134
NESTED LOOPS 23996 1 121
HASH JOIN 23994 1 74
PARTITION LIST ALL
TABLE ACCESS FULL ZK CM_BUSI_CHARGE_200810 708 1492427 34325821
PARTITION HASH ALL
TABLE ACCESS FULL ZK CM_BUSI_PROMO 9519 13553155 691210905
TABLE ACCESS BY GLOBAL INDEX ROWID ZK CM_BUSI_200810 2 1 47
INDEX UNIQUE SCAN ZK PK_CM_BUSI7_200810 1 1
INDEX UNIQUE SCAN XG PK_SYS_ORGANIZATIONS 7 91
TABLE ACCESS BY GLOBAL INDEX ROWID ZK CM_USER 2 1 20
INDEX UNIQUE SCAN ZK PK_CM_USER 1 1 |
|