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

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Mon, 22 May 2017 18:46:48 +0200
Message-ID: <aa882cf5-9730-4ed5-b3d0-9a9c3618ccda_at_bluewin.ch>



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 Received on Mon May 22 2017 - 18:46:48 CEST

Original text of this message