Buy Percona ServicesBuy Now!

Be careful when joining on CONCAT

 | October 16, 2007 |  Posted In: Insight for Developers

The other day I had a case with an awful performance of a rather simple join. It was a join on tb1.vid = CONCAT(‘prefix-‘, with tb1.vid – indexed varchar(100) and – int(11) column. No matter what I did – forced it to use key, forced a different join order, it did not want […]

Read More