Grace  Lesch

Grace Lesch

1621415180

Complete Guide to Database Indexes - Increase Query Speeds

Choosing the right database index

Creating an index does not guarantee better database performance. Every time you write to a table with an index, the database engine is updating both the table and any impacted indexes.

How many indexes should I use?

It depends. If you’re managing a table with frequent changes, then you probably want less overhead with indexes. But on the other hand if you’re making mostly reads from the table, then adding additional indexes would probably speed up performance.

#databases #query speeds #database index

Complete Guide to Database Indexes - Increase Query Speeds