The database index is the data structure that is defined on the columns of the database table. Database indexing speed up the data retrieval process.

There are 3 types of indexing in DBMS:-
  • Primary Index
  • Secondary index
  • Clustered index
BY Best Interview Question ON 18 Mar 2020