title: Is there any alternative of case statement?
body: <p>I have a situation where if the column value is less the 1 then I have to show <code>NO</code> as column value, else <code>YES</code>.  I am using <code>CASE</code> statement for this.  But after applying <code>CASE</code> statement query is taking to much time to execute.  Is there any alternate way of achieving this without using <code>CASE</code>statement?</p>