Things to Consider

• Indexes greatly increase query response time

• every index requires system resources to store and maintain

• indexes can actually slow down the performance of UPDATES, INSERTS, and DELETES due to index maintenance

So… don’t over index

Previous slide

Next slide

Back to first slide

View graphic version