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
词条内容仅供参考,如果您需要解决具体问题
(尤其在法律、医学等领域),建议您咨询相关领域专业人士。
