News for hackers. Stuff that matters.
Re:MySQL is a Better NoSQL by oysteing on Thursday December 10, 2015 @04:29AM (#10709732)
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.
Re:MySQL is a Better NoSQL by jfrisby on Thursday December 10, 2015 @02:43PM (#10712885)
Only if the columns are stored on-page with the index, which is not guaranteed -- it depends on what other columns exist in the table, etc.