Histogram Q
- From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Dec 2006 12:17:47 -0500
Hello Listers.
When I collect statistics of a table using (dbms_stats.gather_table_stats)
method_opt => 'for all columns size 1', I get the table details in
user_tab_histograms for the table. So, technically the table has a
histogram. But this is a histogram with ONE bucket. So, it is NOT a
histogram.
CBO will not treat this as a case of table with histogram. Am I not right in
this conclusion? Can some one confirm?
Thanks,
Shiva
Other related posts:
