“Just Add an Index” Is Terrible Advice. Here’s Why.
Let’s be honest. Your query is slow. You ran EXPLAIN, you saw the execution plan, and you did the obvious thing: you added an index. But the result was disappointing. The speed didn’t improve much, and in some cases, it might have even gotten slower. Why? Wasn’t an index supposed to be the silver bullet? This…