Considerthefollowingstatement:SQL>EXECUTEDBMS_STATS.GATHER_SHEMA_STATS(－2>
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
词条内容仅供参考，如果您需要解决具体问题
（尤其在法律、医学等领域），建议您咨询相关领域专业人士。