题目内容
YourcompanyusesSQLServer2005.Youareimplementingaseriesofviewsthatareusedinadhocqueries.Theviewsareusedtoenforceyourcompanyssecuritypolicyofabstractingdata.Someoftheseviewsperformslowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompanyssecuritypolicy.Oneoftheviewsreturnsthecurrentdateasoneofthecolumns.TheviewreturnsthecurrentdatebyusingtheGETDATE()function.Thisviewdoesnotallowyoutocreateanindex.Youneedtocreateanindexontheview.
Whichtwoactionsshouldyouperform?()
查看答案
搜索结果不匹配?点我反馈