- Advantage
If you create an index on each column of a table, it improves the query
performance, as the query optimizer can choose from all the existing
indexes to come up with an efficient execution plan.
- Disadvantage
- At the same time, data modification operations (such as INSERT,
UPDATE, DELETE) will become slow, as every time data changes in the
table, all the indexes need to be updated.
- Another disadvantage is that, indexes need disk space, the more
indexes you have, more disk space is used.
|
