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
Is a secondary key the same as a foreign key?
What are the types of records?
Can you have more than one key in a database?
what are the properties and different types of sub-queries? : Sql dba
What is cursor and its types?
List out the acid properties and explain?
What are the different ways to optimize a sql query?
what is the difference between join and union? : Sql dba
What is #table in sql?
What are the different types of tables in sql?
Explain table and field in sql?
Explain the advantages and disadvantages of stored procedure?
How do you use collections in procedure to return the resultset?
What is date functions?
What is the difference between inner join and left join?