Index Hints Seems to Be Ignored by Optimizer

(Doc ID 2381118.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 Dumping Hints
=============
 atom_hint=(@=ffffffff7b3e26f0 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E065" "S05E001_IX02") )
 atom_hint=(@=ffffffff7b390418 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E065" "S05E012_IX02") )
 atom_hint=(@=ffffffff7b365188 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E055" "S02E015_IX02") )
 atom_hint=(@=ffffffff7b321c88 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E055" "S05E002_IX04") )
 atom_hint=(@=ffffffff7b314828 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E055" "S05E013_IX02") )
 atom_hint=(@=ffffffff7b592008 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E035" "S05E001_IX02") )
 atom_hint=(@=ffffffff7b5408a0 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E035" "S05E012_IX02") )
 atom_hint=(@=ffffffff7b504ca8 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E025" "S02E015_IX02") )
 atom_hint=(@=ffffffff778034b0 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E025" "S05E002_IX04") )
 atom_hint=(@=ffffffff777134f8 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("E025" "S05E013_IX02") )

  

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms