YourcompanyusesSQLServer2005.Youareimplementingaseriesofviewsthatareusedinadhocqueries.Theviewsareusedtoenforceyourcompanyssecuritypolicyofabstractingdata.Someoftheseviewsperformslowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompanyssecuritypolicy.Oneoftheviewsreturnsthecurrentdateasoneofthecolumns.TheviewreturnsthecurrentdatebyusingtheGETDATE()function.Thisviewdoesnotallowyoutocreateanindex.Youneedtocreateanindexontheview.
Whichtwoactionsshouldyouperform?()