Glossary
An additional structure that lets the database find rows without reading the whole table.
A fitting index turns a query from seconds into milliseconds. It costs storage and slows writes, because it has to be maintained.
Which index fits follows from the actual queries, not from the data model.