oracle归档数据查询（分区查询）(二)
r) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121226) c
UNION ALL
SELECT DISTINCT(c.caller_nbr) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121227) c
UNION ALL
SELECT DISTINCT(c.caller_nbr) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121228) c
UNION ALL
SELECT DISTINCT(c.caller_nbr) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121229) c
UNION ALL
SELECT DISTINCT(c.caller_nbr) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121230) c
UNION ALL
SELECT DISTINCT(c.caller_nbr) AS emp_use_count FROM tab_pub_calllog_his PARTITION(p_20121231) c )
执行不到6秒，结果就出来了，真是够强悍的！