Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */

... or use a slightly modified version of Tanel's hinth SQL script to get more information :-)

NAME VERSION PATH

---------------------------------------------------------------- ---------- ------------------------------------------------------------
NO_USE_INVISIBLE_INDEXES					 11.1.0.6   ALL -> COMPILATION -> CBO -> ACCESS_PATH -> INDEX
USE_INVISIBLE_INDEXES						 11.1.0.6   ALL -> COMPILATION -> CBO -> ACCESS_PATH -> INDEX

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals

> Ls Cheng <exriscer_at_gmail.com> hat am 22. Mai 2017 um 21:16 geschrieben:
>
> Hi
>
> You can find it in v$sql_hint
>
> Regards
>
> On Mon, May 22, 2017 at 8:44 PM, Lothar Flatz <l.flatz_at_bluewin.ch mailto:l.flatz_at_bluewin.ch > wrote:
> > Hi,
> >
> > thanks ! Did you pick this up from an outline?
> >
> > Regards
> >
> > Lothar

--
http://www.freelists.org/webpage/oracle-l