What is Indexing in SQL Server?

Indexes are data structures that help SQL Server locate rows efficiently without scanning the entire table. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.