Histogram Q

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Wed, 13 Dec 2006 12:17:47 -0500
Message-ID: <1e52ad820612130917v5163ae20ufdf56c5ab2a1e91e@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 13 2006 - 11:17:47 CST