首页 资讯 Yourdatabaseis5GBandcontainsatablenamedSalesHistoryS

Yourdatabaseis5GBandcontainsatablenamedSalesHistoryS

Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?()

A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)

B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)

C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘

D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE

参考答案:B

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/zx/414333.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部