News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL by falcolas on Tuesday July 26, 2016 @03:57PM (#12168335)
Indexes like this are also typically in memory to begin with, making it even faster, since you only have to find the actual record on disk.

Even better, if you only need one field from the record, and it's part of a compound index, you can frequently return the data from just the indexes; no disk seeks required. Small tip with InnoDB on MySQL - any non-primary key index is automatically a compound index with the primary key.

There are no comments on this comment yet.