Note that if the CURSOR_SHARING parameter is set to FORCE, some rewrites that were text-match based in 8.1.5 may no longer be possible with 8.1.6.

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.