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 原则详细解答和技术解析，登录匠人学院学习中心即可查看完整答案、收藏题目并进行模拟面试练习。
