Indexing and kinds of indexing

Question

Illustrate the term indexing. Specify the kinds of the indexing.

Answer 1

Indexing refers to the technique that is used for the efficient data retrieval or accessing the data in the faster manner. When the table increases in volume, the indexes also improve in size needing more storage.

Three types of the indexing are:

a) B-Tree indexing.

b) Bit map indexing.

c) Join indexing.