Re: Hint cardinality for predicate
From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 12 May 2010 14:34:57 -0700
Message-ID: <AANLkTimjcRCncSLV-WZZUrUIAGmTS5zB4KgLgcpQuX8v_at_mail.gmail.com>
Can you provide more context for your issue? (and example with plan estimates and actuals would be a start)? Cardinality estimates being off isn't necessarily an issue, if it still yields the desired plan, so what plan do you get and what plan do you want?
Date: Wed, 12 May 2010 14:34:57 -0700
Message-ID: <AANLkTimjcRCncSLV-WZZUrUIAGmTS5zB4KgLgcpQuX8v_at_mail.gmail.com>
Can you provide more context for your issue? (and example with plan estimates and actuals would be a start)? Cardinality estimates being off isn't necessarily an issue, if it still yields the desired plan, so what plan do you get and what plan do you want?
Have you tried different levels of dynamic sampling?
On Wed, May 12, 2010 at 12:53 PM, Ilia Kantor <iliakan_at_gmail.com> wrote:
> I have a multi-predicate query like:
>
> SELECT * FROM table WHERE
> a BETWEEN 5 and 10
> and
> b in (3,4,5)
> and c in (9)
> ...
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 12 2010 - 16:34:57 CDT