As a Rule of Thumb, function evaluation time is not significant to the overall time for running a query. (I see IF and CASE as 'functions' for this discussion.)
Do you have evidence that says that IF is slower? Perhaps using BENCHMARK()? > -----Original Message----- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Monday, February 04, 2013 11:31 PM > To: mysql@lists.mysql.com > Subject: IF and CASE > > It is my impression that when their functions are equivalent, IF takes > more time than CASE. Comment? > > Do they always evaluate all their arguments? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql