Don't be a chump and write slow, crappy code. Refactor and optimize 🤩
Super relevant and helpful, thanks Jess! I was actually just asked about how to optimize my SQL queries in a job interview this morning.
yes that's such a common interview question! These 10 best practices would blow them away ;)
Good stuff, Jess. I would add Window functions to the order of execution. Happens just before theorder by clause.
Great point! Those deserve their own section 😎
Super relevant and helpful, thanks Jess! I was actually just asked about how to optimize my SQL queries in a job interview this morning.
yes that's such a common interview question! These 10 best practices would blow them away ;)
Good stuff, Jess. I would add Window functions to the order of execution. Happens just before theorder by clause.
Great point! Those deserve their own section 😎