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 partition by in sql?
What mean sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
Is sql developer case sensitive?
explain about mysql and its features. : Sql dba
What is clause in sql?
What is normalisation in sql?
What is function and procedure?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What are the different types of functions in sql?
Can we rename a column in the output of sql query?
Explain what is table in a database?
Explain unique key in sql.
What is the difference between partition and index?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.