It potentially, and likely, creates an awful lot of histograms exactly
BECAUSE the method_opt setting of 'for all columns size 1' is ignored
and replaced with 'for all columns size auto'.
Allen, Brandon wrote:
It wouldn't create any more histograms than any other method - Oracle creates histograms of size 1 for all columns by default.
That would create an awful lot of histograms if method_opt was observed.. Fortunately, it is ignored with
GATHER AUTO. Here is what the fine manual says:
-- Regards
Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l