Covering Index
Learn Covering Index (Indexes, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A covering index contains every column a query needs, so MySQL answers it from the index alone without reading the table rows. EXPLAIN shows Using index in Extra.