Index Condition Pushdown Optimization in MySQL
Big Idea Getting under the hood of database implementations is becoming an area of growing interest for me. Early in my career, I was always content with SQL as an interface to a datastore that “just works.” That is, until it doesn’t anymore. It’s at those points that I am now being pushed to understand why a particular database implementation has certain behavioral characteristics in different circumstances. Further, I have never crossed paths with a professional DBA and often feel like there’s a whole sphere of mystery for me here....