Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | STAR_TRANSFORMATION_ENABLED =
|
Default value | FALSE |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Basic | Yes |
STAR_TRANSFORMATION_ENABLED
determines whether a cost-based query transformation will be applied to star queries.
Values:
TRUE
The optimizer will consider performing a cost-based query transformation on the star query.
FALSE
The transformation will not be applied.
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:
|