What is a covering index and how does it reduce table lookups?

What is a covering index and how does it reduce table lookups?

题目类型: 技术面试题

这是一道技术面试题，常见于澳洲IT公司面试中。

难度: hard

标签: interviewbit, dbms, topic-specific, database

参考答案摘要

A covering index contains all the columns needed by a query. This allows the database to fetch results directly from the index without accessing the table. As a result, fewer disk reads are needed. Th...

本题提供 STAR 原则详细解答和技术解析，登录匠人学院学习中心即可查看完整答案。