| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | STAR_TRANSFORMATION_ENABLED = { FALSE | TRUE | TEMP_DISABLE } |
| 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:
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 Concepts for information on star queries
Oracle Database Performance Tuning Guide for information on enabling star query