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

  • From: Lothar Flatz <l.flatz@xxxxxxxxxx>
  • To: Dominic Brooks <dombrooks@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 22 May 2017 20:44:14 +0200

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 <mailto:l.flatz@xxxxxxxxxx>
*Sent: *22 May 2017 17:48
*To: *oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
*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

--




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



--




Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2017