What Are The Merits And Demerits Of Having An Index In Sql Server?

1.	What Are The Merits And Demerits Of Having An Index In Sql Server?
Answer» There are various MERITS and demerits of index usage in SQL server. Some of them can cite as: Indexes can help speed up a SELECT QUERY. One can also SEARCH against large string values, given index is set to full-text index. Indexes help to make a row unique or without any duplicate. Some disadvantages can be: Indexes take additional space; thus, disk size is being occupied. An index can slow down the basic operation LIKE insert, delete, and update but if where the condition has an index field, then update operation can be faster. Insert, delete, or update becomes slower since after each operation index must be updated. There are various merits and demerits of index usage in SQL server. Some of them can cite as: Some disadvantages can be:

Answer»

There are various MERITS and demerits of index usage in SQL server. Some of them can cite as:

Indexes can help speed up a SELECT QUERY.
One can also SEARCH against large string values, given index is set to full-text index.
Indexes help to make a row unique or without any duplicate.

Some disadvantages can be:

Indexes take additional space; thus, disk size is being occupied.
An index can slow down the basic operation LIKE insert, delete, and update but if where the condition has an index field, then update operation can be faster. Insert, delete, or update becomes slower since after each operation index must be updated.

There are various merits and demerits of index usage in SQL server. Some of them can cite as:

Some disadvantages can be:

Discussion