Data modelling - Concept
Database index
(DB index)
An extra structure that helps a database find records faster
What's it for?
Helps a database find particular records faster without checking every row.
For example…
A database index on CustomerID lets the system jump to one customer's record instead of scanning millions of rows.
Adding an index makes order searches much faster, although it adds some storage and work when records are updated.