Indexes are the objects of MS SQL database files. These schema objects act like a table of contents of the database. These are used to improve the data retrieval operations on an MS SQL database table. 

However, with time, the table can get fragmented due to continuous INSERT and UPDATE operations. Also, like other objects, indexes are also prone to corruption. If the indexes get corrupted, you can receive errors like: