What is index and also explain types of indexing in DBMS?
The database index is the data structure which 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