Recently, requests to one of our data-backed web services started timing out. It turned out the problem was that some of our data tables had been (re)created using the wrong character sets and collations. And as everyone should know, and now I do: Indexes are useless for joins unless the collations match The carefully optimized queries…