Inserts / updates / deletes indexes of automatic updating of records?

Question

Does inserting / updating or deleting a record in the database automatically update indexes?

I saw rebuild commands for indexes, and I just can't figure out if I have to do all this manually, and then what is the purpose of the indexes. This is so inconvenient that I spend time recovering indexes every week or so.

Answer 1

When index fragmentation becomes too high, indexes will be very inefficient. It is necessary to rebuild the index.

Let SQL Server tell you which indexes to rebuild

Index recovery crashes and recreates the index. This eliminates fragmentation, restores disk space by compacting pages based on an existing fill factor setting, and reorders index rows on adjacent pages.

Reorganization and restoration of indexes

Answer 2

Yes, when you insert, update, or delete row, any indexes in this table automatically reflect the change.