STAR_TRANSFORMATION_ENABLED

Parameter type	String
Syntax	STAR_TRANSFORMATION_ENABLED = {TEMP_DISABLE | TRUE | FALSE}
Default value	FALSE
Parameter class	Dynamic: ALTER SESSION

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: Oracle9i Database Concepts for information on star queries Oracle9i Database Performance Tuning Guide and Reference for information on enabling star query