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

  • From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
  • To: "l.flatz@xxxxxxxxxx" <l.flatz@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 22 May 2017 18:01:54 +0000

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