Inyourtestdatabase,youhavecreatedtheORDERStableasanindex-organizedtable(IOT).Tofacilitatefasterquerying,youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegreeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason,youfindthatthemappingtablesegmentisfragmented,leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata?()

A.Exportandimportthemappingtable. B.Dropandre-createthemappingtable. C.Truncatethemappingtableandreinsertthevalues. D.UsetheALTERTABL E..REBUILDcommandtodefragmentthemappingtable.

时间:2023-09-09 17:36:49

相似题目

推荐题目