Miscellaneous

Commonly Used Hints

Using Query Blocks in Hints

Unsupported Hints

Hints for Access Paths

Hints for Join Orders

Hints for Join Operations

  • USE_NL and NO_USE_NL
  • USE_NL_WITH_INDEX
  • USE_MERGE and NO_USE_MERGE
  • USE_HASH and NO_USE_HASH
  • NO_USE_HASH

Hints for Online Application Upgrade

  • CHANGE_DUPKEY_ERROR_INDEX
  • IGNORE_ROW_ON_DUPKEY_INDEX
  • RETRY_ON_ROW_CHANGE

Hints for Parallel Execution

  • PARALLEL and NO_PARALLEL
  • PARALLEL_INDEX and NO_PARALLEL_INDEX
  • PQ_DISTRIBUTE

Hints for Query Transformations

  • NO_QUERY_TRANSFORMATION
  • USE_CONCAT
  • NO_EXPAND
  • REWRITE and NO_REWRITE
  • MERGE and NO_MERGE
  • STAR_TRANSFORMATION and NO_STAR_TRANSFORMATION
  • FACT and NO_FACT
  • UNNEST and NO_UNNEST

Additional Hints

  • APPEND, APPEND_VALUES, and NOAPPEND
  • CACHE and NOCACHE
  • PUSH_PRED and NO_PUSH_PRED
  • PUSH_SUBQ and NO_PUSH_SUBQ
  • QB_NAME
  • CURSOR_SHARING_EXACT
  • DRIVING_SITE
  • DYNAMIC_SAMPLING
  • MODEL_MIN_ANALYSIS

Useful Initializtion Parameters

Optimizer Adaptive Features
Max Idle Blocker Time

Useful Features of the Oracle Database

Real-Time Statistics (19c Exadata or Engineered Systems Only)


Published 24th May 2022

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License