Considerthefollowingstatement：SQL>EXECUTEDBMS_STATS.GATHER_SHEMA_STATS（-2>ownname=>‘OE’，-3>estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE，-4>methodopt=>‘forallcolumnssizeAUTO’）；Whatistheeffectof‘forallcolumnssizeAUTO’oftheMETHOD_OPToption？（）
A.TheOracleservercreatesanewhistogrambasedonexistinghistogramdefinitionsforalltable,column,andindexstatisticsfortheOEschema.
B.TheOracleservercreatesahistogrambasedondatadistributionregardlessofhowtheapplicationusesthecolumn/sforalltable,column,andindexstatisticsfortheOEschema.
C.TheOracleservercreatesahistogrambasedondataandapplicationusageofthecolumn/sforalltable,column,andindexstatisticsfortheOEschema.
D.TheOracleservercreatesahistogrambasedonapplicationusage,regardlessofdatadistribution,foralltable,column,andindexstatisticsfortheOEschema.
正确答案：参考C
