Re: Bitmap index costing - how to influence
From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 28 Mar 2009 19:59:31 -0700
Message-ID: <a9c093440903281959u34db892bvcab160044a5f1d89_at_mail.gmail.com>
Why use undocumented OPT_PARAM when INDEX_COMBINE is documented and provided?
Date: Sat, 28 Mar 2009 19:59:31 -0700
Message-ID: <a9c093440903281959u34db892bvcab160044a5f1d89_at_mail.gmail.com>
Why use undocumented OPT_PARAM when INDEX_COMBINE is documented and provided?
On Sat, Mar 28, 2009 at 2:10 PM, Randolf Geist <info_at_sqltools-plusplus.org>wrote:
> if you can influence the query, then you can try to lower the cost of the
> bitmap index access specifically to that query by using the (undocumented)
> OPT_PARAM hint introduced in 10g:
>
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 28 2009 - 21:59:31 CDT