QUERY_REWRITE_ENABLED

Parameter type	Boolean
Default value	false
Parameter class	Dynamic: ALTER SESSION, ALTER SYSTEM
Range of values	true | false
Oracle9i Real Application Clusters	Multiple instances can have different values.

QUERY_REWRITE_ENABLED allows you to enable or disable query rewriting globally for the database.

To take advantage of query rewrite for a particular materialized view, you must enable query rewrite for that materialized view, and you must enable cost-based optimization.

See Also: Oracle9i Data Warehousing Guide for information on query rewrite of materialized views Oracle9i Database Performance Guide and Reference and "OPTIMIZER_MODE" for information on cost-based optimization