Name
QUERY_REWRITE_ENABLED
Synopsis
Value: TRUE | FALSE
Default: FALSE
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies whether query rewrites of materialized views will be enabled globally for the database. To take advantage of query rewrites, you must enable this option for each materialized view, and you must enable cost-based optimization. New with Oracle9i.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.