STAR_TRANSFORMATION_ENABLED

Property	Description
Parameter type	String
Syntax	`STAR_TRANSFORMATION_ENABLED =` `{TEMP_DISABLE \| TRUE \| FALSE}`
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:

Oracle Database Concepts for information on star queries

Oracle Database Performance Tuning Guide for information on enabling star query