Last answered:

13 Mar 2023

Posted on:

11 Mar 2023


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)
Posted on:

13 Mar 2023


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.

Submit an answer