Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/Databases
Databasesmedium

What is a covering index (index‑only scan) and why can it be faster?

Tags
#database#indexes#covering-index#performance
Back to categoryPractice quiz

Answer

A covering index contains all columns needed by a query, so the DB can answer it using only the index without fetching table rows. This reduces I/O and can be much faster, especially on large tables.

Related questions

Databases
Autocommit vs explicit transactions: when does it matter?
#database#transactions#autocommit
Databases
OLTP vs OLAP: what’s the difference?
#database#oltp#olap
Databases
Denormalization: when might you do it and what’s the trade‑off?
#database#denormalization
#performance
Databases
Partitioning vs sharding: what’s the difference?
#database#partitioning#sharding
Databases
Isolation levels: what’s the difference between Read Committed, Repeatable Read, and Serializable?
#database#transactions#isolation
Databases
Deadlock: what is it and how do databases resolve it?
#database#transactions#locks