What are the tradeoffs with having indexes?
Question : What are the tradeoffs with having indexes?
Faster selects, slower updates.
Extra storage space to store indexes. Updates are slower because in
addition to updating the table you have to update the index.