June 19, 2013

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

… * FROM TBL WHERE hash=crc32(‘string‘) AND string=’string‘ The other thing you need to consider is string comparison in MySQL is case insensitive by default… least good to convert it in binary form and store as VARBINARY(16) for performance reasons. In any case you would likely to get…

Filed Under: Insight for DBAs, MySQL