On Mon, Dec 15, 2008 at 1:15 PM, Ashish Thusoo <[email protected]> wrote: > There is a lot of work done on a technology called materialized views which > can provide a lot of these benefits in a very useable manner, though at the > expense of using more disk storage. Essentially, the idea is to materialize > views of data and keep them updated when data changes.
The other part is how they are used. The database can rewrite queries to use the materialized view instead of the base tables. This rewrite happens automatically, without any code changes or requiring users to know about the materialized views. A database tool can analyze queries and suggest materialized views to create.
