1.

Explain the structural difference between bitmap and b-tree index.

Answer»
BitmapB-tree Index
Bitmap consists of BITS for every PARTICULAR single value.Bitmap consists of branch nodes and LEAF nodes.
It uses strings to locate elements of tables (ROWS and columns)It helps to keep the data sorted and ARRANGED in DBMS.
Related Article Linkedin Interview Questions


Discussion

No Comment Found