Question

advantages and disadvantage of dense and sparse indexing​

Answer 1

Answer:

Advantages of indexing

There are many advantages of indexing. Some of the advantages are mentioned here.

• Better performance of queries.
• Fast searching from the database.
• Fast retrieval of data.
• Increase performance in SELECT query

Disadvantages of indexing

• Indexing takes more space.
• Decrease performance in INSERT, DELETE and UPDATE query.