What Are The Tradeoffs With Having Indexes?

1.	What Are The Tradeoffs With Having Indexes?
Answer» 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.

Answer»

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.

Discussion