2.389 STAR_TRANSFORMATION_ENABLED
STAR_TRANSFORMATION_ENABLED
determines whether a cost-based query transformation will be applied to star queries.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
Yes |
Values
-
FALSE
The transformation will not be applied.
-
TRUE
The optimizer will consider performing a cost-based query transformation on the star query.
-
TEMP_DISABLE
The optimizer will consider performing a cost-based query transformation on the star query but will not use temporary tables in the star transformation.
See Also:
-
Oracle Database SQL Tuning Guide for information on enabling star queries