omoutop - 7:08 am on Nov 8, 2012 (gmt 0)

<=, => and BETWEEN have some performance differences, but only noticeable in very large data sets (as far as i understand it)

as for the switch statement, it's just another if-else statement expressed differently