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

• From: Lothar Flatz <l.flatz@xxxxxxxxxx>
• To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
• Date: Mon, 22 May 2017 18:46:48 +0200

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

• Follow-Ups:
  • RE: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */
    • From: Dominic Brooks

Other related posts:

• » /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */ - Lothar Flatz
• » RE: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Dominic Brooks
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Lothar Flatz
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Ls Cheng
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Stefan Koehler
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Lothar Flatz
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Anton
• » Re: /*+ opt_param('OPTIMIZER_USE_INVISIBLE_INDEXES' 'TRUE') */- Stefan Koehler

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

---

• » Previous by Date
• » Next by Date
• » Related Posts
• » View list details
• » Manage your subscription

---