Re: Hint cardinality for predicate
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: iliakan@xxxxxxxxx
- Date: Wed, 12 May 2010 14:34:57 -0700
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
