Sql server - Disadvantages of the Indexes

Disadvantages of the Indexes.

- Every time data changes in the table, all the indexes need to be updated.

- Indexes need disk space. The more indexes you have, more disk space is used.

- Index decreases the performance on inserts, updates and deletes.

- It slows down the query performance.
Sql server - Define Clustered and Non-Clustered Index
A clustered index reorders the way records are stored. A non clustered index is in which the logical order of the index does not match the physical stored order of the rows on disk......
Sql server - What is Unique Index?
Unique index is the index that is applied to any column of unique value........
Sql server - Difference between clustered and non-clustered index
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data........
Post your comment