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

Thanks to everybody. You saved me some time when I most needed it. :-)

On 22.05.2017 21:26, Stefan Koehler wrote:
> ... 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
>
> Best Regards
> Stefan Koehler
>
> 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