What is a bitmap index?
Answer Posted / pinkey
Bitmap indexes are widely used in data warehousing
environments. The environments typically have large amounts
of data and ad hoc queries, but a low level of concurrent
DML transactions. For such applications, bitmap indexing
provides:
Reduced response time for large classes of ad hoc queries
Reduced storage requirements compared to other indexing
techniques
Dramatic performance gains even on hardware with a
relatively small number of CPUs or a small amount of memory
Efficient maintenance during parallel DML and loads
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can a commit statement be executed as part of a trigger?
Explain the structure of pl/sql in brief.
What is set serveroutput on?
What is data type in database?
What is constant in pl sql?
What is a full join?
how to convert numeric values to character strings? : Sql dba
How do I kill a query in postgresql?
Can we group by two columns in sql?
What are the different types of dbms?
How do you declare a variable in pl sql?
How to avoid duplicate records in a query?
Is microsoft sql free?
What is vector point function?
What are expressions?