Re: Hint cardinality for predicate


Yes, of course I did. That helps an extremely tiny little bit.
Multicolumn is just a column with up to 255 histogram buckets (yes I
have skew too).

That's far less information then count(distinct country) different
statistic sets.

2010/5/13 Flora Deng <hdeng@xxxxxxxxxxxxxxxx>:
> Hi,
> Did you try the multicolumn statistics since it's 11G new feature?
> e.g.
> select
> dbms_stats.create_extended_stats('schema_name','table_name','(a,b,c)') from
> dual;
> exec dbms_stats.gather_table_stats('schema_name','table_name', -
> method_opt=>'for all column size 1 for columns (a,b,c) size 3');
> Flora

Other related posts: