Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Library
Product
Contents
Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 178 of 188

STAR_TRANSFORMATION_ENABLED

Parameter type: 

String 
Syntax: 

STAR_TRANSFORMATION_ENABLED =

{TRUE | FALSE | TEMP_DISABLE} 
Parameter class: 

Dynamic. Scope = ALTER SESSION. 
Default value: 

FALSE 

STAR_TRANSFORMATION_ENABLED determines whether a cost-based query transformation will be applied to star queries.

  • 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:  

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index