Data Warehouse Case 1

问题:分层聚合,日->月->季度->年,慢到一整天都跑不完
解决:
insert , delete -> partition
router (cursor, when exist then update, when not exist then insert)
11g compression
no archive, no logging
parallel
结果:23 hour -> 1 hour

Reference:
http://www.itpub.net/thread-1628078-4-1.html