Index

Question 1

What is an index?

Answer 1

The goal of creating an index on a particular table in a database is to make it faster to search through the table and find the row or rows that we want. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Question 2

Advantage of Index

Answer 2

Makes reading faster

Question 3

Disadvantage of Index

Answer 3

The downside is that indexes make it slower to add rows or make updates to existing rows for that table since we not only have to write the data but also have to update the index. So adding indexes can increase the read performance, but at the same time, decrease the write performance. This performance degradation applies to all insert, update, and delete operations for the table.