#indexing

TIL: What Are Sargable Queries?

While working on query optimization recently, I came across the concept of sargable queries — short for Search ARGument-able. It's all about writing SQL in a way that lets your database use indexes effectively, which can make a huge difference in per...