The previous installment of Use The Index, Luke finalized the section on function based indexes by explaining the limitations they have.
Today's installment covers a topic that can't be stressed enough: the proper use of bind parameters in SQL.
Although the most important reason to use bind parameters is the prevention of SQL injection, bind parameters have a positive impact on performance but might affect index selection.
PS: Wanna look further down the road? I just blogged about an index related performance optimization in MySQL.
PPS: Need Help Right Now? Check out my Instant-Coaching offer.