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
What is a primary key example?
Are pl sql variables case sensitive?
what are date and time data types in mysql? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
Write a query to find the names of users that begin with "um" in sql?
what is not null constraint? : Sql dba
What are the types of index in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
explain primary keys and auto increment fields in mysql : sql dba
What is date functions?
How can we find duplicate records in a table?
What is sql*loader?
How to pipe multiline string to isql?
What is not equal in sql?
How do you clear the screen in sql?