Re: Hint cardinality for predicate

Hello,

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
>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: