Bitmap Indexing
Q.1: What is indexing in Bitmaps?
Answer:
Indexing in the bitmap is a technique used to manage and improve the performance of read-only queries involving large datasets.
Q.2: Why is Bitmap Index used?
Answer:
Bitmap Index is used to reduce the response time for large classes and queries.
Q.3: Give some examples of Bitmap?
Answer:
Some examples of Bitmap are GIF, JPEG, PNG, etc.
Bitmap Indexing in DBMS
Bitmap Indexing is a data indexing technique used in database management systems (DBMS) to improve the performance of read-only queries that involve large datasets. It involves creating a bitmap index, which is a data structure that represents the presence or absence of data values in a table or column.
In a bitmap index, each distinct value in a column is assigned a bit vector that represents the presence or absence of that value in each row of the table. The bit vector contains one bit for each row in the table, where a set bit indicates the presence of the corresponding value in the row, and a cleared bit indicates the absence of the value.