Query transformation hints
The following hints direct the optimizer to transform the submitted query:
- USE_CONCAT
Forces an OR list to be transformed into a UNION ALL compound query.
- NO_EXPAND
Prevents OR expansion for the query. New with Oracle8i.
- REWRITE
Forces the use of materialized views. New with Oracle8i.
- EXPAND_GSET_TO_UNION
Forces query using grouping sets to be transformed into a UNION ALL compound query. New with Oracle9i.
- NOREWRITE
Prevents query rewrite for materialized views. New with Oracle8i.
- MERGE( table )
Specifies merging a view with a query. Complex view merging must be enabled for this hint to operate.
- NO_MERGE( table )
Disallows complex view merging.
- STAR_TRANSFORMATION
Suggests, but does not force, a transformation of the query into a star query.
- FACT( table )
Specifies that the table is used as the fact table in a star transformation. New with Oracle9i.
- NO_FACT( table )
Specifies that the table should not be used as the fact table in a star transformation. New with Oracle9i.