This article explores the internals of materialized views and demonstrates how to precompute complex aggregates—having Oracle dynamically rewrite SQL to reference precomputed aggregate information.

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.