materialized view can be used as summary tables

Gothru this:

http://download-west.oracle.com/docs.../a96520/mv.htm