System Design: Indexes Flashcards
1
Q
What is the goal of creating an index in a databse?
A
The goal of creating an index on a particular table in a database is to make it faster to search through the table and find the row or rows that we want.
2
Q
Can non-relational DBs have indices?
A
Yes
3
Q
What is the primary draw-back of databse indexes?
A
They slow down write time.
