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: