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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 16:44:45 CDT
