HNHacker News
TopNewBestAskShowJobs

oysteing

1 karma · joined December 10, 2015

submissionscomments
oysteing··on MySQL is a Better NoSQL
You are right that this join query should be equivalent. However, with InnoDB there will not be much benefit from your suggested index. In InnoDB primary indexes are clustered. Hence, any column may be retrieved from the B-tree of the primary index.