Re: Bitmap index costing - how to influence

From: Randolf Geist <info_at_sqltools-plusplus.org>
Date: Sun, 29 Mar 2009 14:02:35 +0200
Message-Id: <570087635_at_web.de>

> Why use undocumented OPT_PARAM when INDEX_COMBINE is documented and
> provided?

Greg,

thanks for making that point. I generally second that one shouldn't use undocumented parameters/features if possible. Unfortunately Oracle doesn't provide (yet) an officially documented way to influence parameters like OICA / OIC on statement level, that's why I suggested it in this particular case to limit the effects of this parameter as much as possible.

There are obviously many different possibilities how the index usage in this particular case could be hinted/forced, but the INDEX_COMBINE and the OPTIMIZER_INDEX_COST_ADJ suggestions provide quite different means, so it depends what the objective is in the particular situation.

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows): http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/

---

Verschicken Sie SMS direkt vom Postfach aus - in alle deutschen und viele ausländische Netze zum gleichen Preis!
https://produkte.web.de/webde_sms/sms

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

Received on Sun Mar 29 2009 - 07:02:35 CDT