YouworkwithadatabasenamedDB1,whichislocatedonaSQLServer2005computer.Youdiscoverthatatables

题目内容(请给出正确答案)

YouworkwithadatabasenamedDB1,whichislocatedonaSQLServer2005computer.YoudiscoverthatatablescanonTable1inDB1causesaslowquery.Table1isaverylargetablethatisusedfrequently.Youascertainthatthequerycontainsthefollowingstatement.SELECTcol1,col2FROMtable1WHEREcol3=Youneedtoprovidemaximumqueryperformance.Table1mustremainavailabletousers.Whatshouldyoudo?()

A.UpdateallstatisticsonTable1inDB1.

B.UsetheCREATESTATISTICSstatementinDB1tocreatemissingstatisticsoncol3ofTable1.

C.Setthepriorityboostserveroptionto1.

D.Executethefollowingstatement.USEDB1GOCREATEINDEXindex1ONtable1(col3)INCLUDE(col1,col2)WITH(ONLINE=ON)GO

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。