Sql - null인값 WHERE조건문에 사용시

Reading time ~1 minute

인덱스를 타지 않음

 AND TC.SECTION_CD = CASE WHEN ISNULL(@SECTION_CD,'') <> '' 
                          THEN @SECTION_CD ELSE TC.SECTION_CD END

AND (
    ISNULL(@SECTION_CD,'')=''
    OR
    TC.SECTION_CD = @SECTION_CD
)