December 2002
Intermediate to advanced
928 pages
85h 29m
English
QUERY_REWRITE_ENABLED
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.