Question:What is wrong with the following query in accordance with performance?

SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name' 

A The required keyword ('name') is already in the LOWER case 
B The query requires more time to convert to the LOWER case 
C T-Sql is not case sensitive. Hence, the LOWER keyword is not required 
D Instead of '=' the operator, 'LIKE' should be used 

+ Answer
C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

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

Description