Interested to Buy Any Domain ? << Click Here >> for more details...
What is a bitmap index?
- 4 Answers
- 24009 Views
- Choice Solutions, Infosys, I also Faced
- E-Mail Answers
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 are analytical functions in sql?
What does the sign mean in sql?
What does sign mean sql?
What are views in sql?
What are all ddl commands?
List the different type of joins?
What is the difference between inner join and outer join?
What are the different types of database management systems?
What is count * in sql?
What is the difference between clustered and non-clustered indexes?
what is the difference between cluster and non cluster index? : Sql dba
Is sql between inclusive?
What does stand for in sql?
how to use case expression? : Sql dba
what is a trigger in mysql? : Sql dba
