OPTIMIZER_SECURE_VIEW_MERGING

Property	Description
Parameter type	Boolean
Default value	`true`
Modifiable	`ALTER SYSTEM`
Range of values	`true \| false`
Basic	No
Real Application Clusters	Multiple instances can have different values

OPTIMIZER_SECURE_VIEW_MERGING enables or disables view merging globally for the database.

Values:

false

Oracle does not use view merging or predicate move-around.
true

Oracle assesses the query, considering all transformations, and chooses the method with the lowest cost.

To take advantage of query rewrite for a particular query, you must disable the OPTIMIZER_SECURE_VIEW_MERGING parameter.