More precisely, if you only select indexed columns you can read only from the index rather than read from index then read the rest of columns from table. Usuall

More precisely, if you only select indexed columns you can read only from the index rather than read from index then read the rest of columns from table. Usually the indices are entirely in memory as well, so it's buttery smooth, whereas a read from the table will probably require a disk read.