Considerthefollowingstatement:SQL>EXECUTEDBMS_STATS.GATHER_SHEMA_STATS(－2>ownname=&g

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.