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

Hi

You can find it in v$sql_hint

Regards

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Mon, May 22, 2017 at 8:44 PM, Lothar Flatz <l.flatz_at_bluewin.ch> wrote:

> Hi,
>
> thanks ! Did you pick this up from an outline?
>
> Regards
>
> Lothar
>
>
> On 22.05.2017 20:01, Dominic Brooks wrote:
>
> The /*+ use_invisible_indexes */ hint exists instead.
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *Lothar Flatz <l.flatz_at_bluewin.ch>
> *Sent: *22 May 2017 17:48
> *To: *oracle-l_at_freelists.org
> *Subject: */*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */
>
>
>
> Hi
>
> it seems the opt_param hint does not work with
> ‘OPTIMIZER_USE_INVISIBLE_INDEXES’.
> If that holds true it is unfortunate. Maybe I am overlooking something.
> Can somebody shet more light on this? (e.g. give an explaination.)
>
> Thanks
>
> Lothar
>
> --
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
>
>
>
>
>
>

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