Skip to main content

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.

More lessons in Indexes