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.
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