Re: Hint cardinality for predicate
- From: Ilia Kantor <iliakan@xxxxxxxxx>
- To: Flora Deng <hdeng@xxxxxxxxxxxxxxxx>
- Date: Thu, 13 May 2010 00:43:11 +0400
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
