What is an Index in a Database? #3629
-
|
What is an Index in a Database? |
Beta Was this translation helpful? Give feedback.
Answered by
NadeeshaMedagama
Jun 28, 2026
Replies: 1 comment
-
|
A database index is a data structure that speeds up searching for records. Without an index, the database may need to scan every row. Example Imagine a book. Without an index, you read every page to find a topic. With an index, you jump directly to the correct page. The same idea applies to databases. |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
janedoe2026
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
A database index is a data structure that speeds up searching for records.
Without an index, the database may need to scan every row.
Example
Imagine a book.
Without an index, you read every page to find a topic.
With an index, you jump directly to the correct page.
The same idea applies to databases.