1.

What are the advantages and disadvantages of indexing in DBMS?

Answer»

Indexing is a technique for improving the database PERFORMANCE by reducing the number of disc accesses needed when a query is run. It's a data structure strategy for finding and accessing data in a database rapidly.

The following are some of the benefits of indexes:

  • An index allows data to be RETRIEVED quickly.
  • When an index is used in a query, the performance usually improves dramatically.
  • They're GOOD for sorting. It is possible to eliminate the need for a post-fetch-sort procedure.
  • The index ensures that each record in the database is UNIQUELY identified.

The cons of indexing are:

  • Inserts, updates, and deletes are all slowed down by indexes.
  • Indexes take up a lot of space (this INCREASES with the number of fields used and the length of the fields).


Discussion

No Comment Found

Related InterviewSolutions