What is an index?hard
Answer
An index helps a database find rows faster.
Explanation
Indexes reduce read cost but add storage and write overhead because index structures must be maintained when data changes.
Follow-upWhy can too many indexes hurt performance?