Question 1
===========

Let us take this example..

begin
DBMS_STATS.GATHER_TABLE_STATS('INVENTORY','SALES', METHOD_OPT => 'FOR COLUMNS SIZE 1 ERDAT');

end;

What is FOR COLUMNS SIZE 1 ?. What does it mean the number 1?


Question 2
==========

I was reading this link ..

http://www.dbspecialists.com/special...st2005-01.html

From this link, DBMS_STATS is good when we compare to ANALYZE statment due to below points.

1. DBMS_STATS has parallel statistics collection
2. DBMS_STATS gathering statistics only when existing statistics are stale
3. gathering partition-level and subpartition-level statistics
4. GATHER_SYSTEM_STATS is not available in ANALYZE

My question is, does DBMS_STATS gather statistics
when existing statistics are stale??

Question 3
=========

does ANALYZE command generate Historgrams?