Interview Q&A / SQL & DBMS

1. What are the disadvantages of having too many indexes?

   Every index uses disk and memory, and must be updated on each INSERT, UPDATE and DELETE, which slows writes. Extra indexes can also confuse the optimizer and slow maintenance such as bulk loads and backups.

   BeginnerQuick answer1 min read
2. What is an index in a database and how does it speed up queries?

   An index is a separate sorted structure, usually a B-tree, that maps column values to row locations. It lets the database jump to matching rows instead of scanning the whole table, at the cost of extra storage and slower writes.

   BeginnerQuick answer1 min read