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 are sql injection vulnerabilities?
Can pl sql procedure have a return statement?
Explain raise_application_error.
How do I trace sql profiler?
What is rtm stands for?
Is not equal in sql?
What are two statement types in sql?
what is union, minus and interact commands? : Sql dba
What is crud diagram?
What is sql select statement?
Why do we need a foreign key?
How do I debug a stored procedure?
How to write a query to show the details of a student from students table whose
Does sql view stored data?
What are the types of variable use in pl sql?