Question:Which of the following is a valid code to change the index created on a column of a table to page compression? 

A ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO 
B ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO 
C ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO 
D ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO 

+ Answer
B 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description