Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently user need to run following two statements to collect stats:
analyze table T compute statistics;
analyze table T compute statistics for columns;
Its little confusing for users that they need to collect both stats. Since basic stats are cheap to compute, we should collect them even in case of column stats, so that by running single statement users can get all stats. This leaves with the possibility of fast basic stats collection with first statement which will be good to have.