Resolved: Are indexes updated?
If we work with a database that is constantly updated, does it makes sense to have indexes? Do they update on new INSERT/UPDATE/DELETE values? Thanks!
1 answers ( 1 marked as helpful)
Hi Anas!
Thanks for reaching out.
Yes, using indexes is efficient, but too many indexes is not a good practice, as it will slow the performance. The index is updated every time there is an insert/update/delete executed for that table.
Hope this helps.
Best,
Tsvetelin