In the world of database architecture, the need to dynamically create complex objects conflicts with the demand for subsecond response time. Oracle's answer to this dilemma is the materialized view.

I want to query a table with a date field and an integer field for the count of records by hour and type. I plan to store each hour's count as one row. There are a ...