Today, a coworker ask me about how take stats on tables without histogram. The next sentence get analyze the table without statistics;
exec dbms_stats.gather_table_stats(user,tabname=>’MYTABLE’,method_opt=>’FOR ALL COLUMNS SIZE 1′,estimate_percent=>100,cascade=>TRUE);
You can take not histograms by columns, for this task please modify the clause method_opt, like the following example;
method_opt => ‘for columns <your_column> size 1’
In my opinion histograms are good in columns, specially where it is used for join. I think you have a good reason for not use them.
HTH – Antonio NAVARRO