Index Selection

• on Primary and Foreign Keys—especially important for Joins!

• on Fields that will be “WHERE claused” or ORDER BY’ed

• Long text fields or fields with high redundancy may be less efficient

Previous slide

Next slide

Back to first slide

View graphic version