Is there a performance hit selecting rows based upon a constructed CASE column?
Quick question. I think there is no difference, but I need to be sure.
In a SELECT or INSERT statement if I use a CASE statement to create a new column and then select rows based upon the value of that new column, is it any slower (or faster) than simply repeating the logic of the CASE statement as a direct WHERE condition?
I'm processing a *lot* of data with nasty string functions and I need every ounce of optimisation I can get :)