Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | OPTIMIZER_SECURE_VIEW_MERGING = {false | true | force} |
Default value | true |
Modifiable | ALTER SYSTEM |
Real Application Clusters | Multiple instances can have different values |
OPTIMIZER_SECURE_VIEW_MERGING
allows you to enable or disable 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.