Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • ORDERED - usually used with USE_NL to prevent Oracle from using hash joins
  • INDEX(t index_name) - suggest using this index (and not a different one)
  • NO_INDEX - discourage index usage
  • INDEX_COMBINE - suggest merging bitmap indexes
  • FIRST_ROWS(thumbs down) (n) - suggest query makes sense to use the first rows of result
  • PARALLEL - suggest parallel query
  • GATHER_PLAN_STATISTICS - sql trace
  • CARDINALITY - provide better information
  • BIND AWARE - force bind aware cursor sharing

...

Suggest a FULL TABLE SCAN method to be used:

Panel

SELECT /+ FULL(error) (x)/ FROM tab1 x WHERE col1 = 10;

...