Youhavearange-partitionedtableinyourdatabase.Eachpartitioninthetablecontainsthesalesdataforaquarter.
Thepartitionrelatedtothecurrentquarterismodifiedfrequentlyandotherpartitionsundergofewerdatamanipulations.Thepreferencesforthetablearesettotheirdefaultvalues.Youcollectstatisticsforthetableusingthefollowingcommandinregularintervals：SQL>EXECUTE
DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；
Youneedstatisticstobecollectedmorequickly.
Whatcanyoudotoachievethis？（）