what is the bitmap index?
- 3 Answers
- 7143 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / a g srikanth
Bitmap Index is an index that can be used on low
cardinality columns with a large number of rows. Low
cardinality columns are the ones with less number of
distinct values (eg.gender columns with just two distinct
values Male & Female).
Bitmap indexes are also useful in DWH applications where a
large table is joined with many small tables in a
denormalized star schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / daid kumar
bitmap Index is Used mainly in decision support systems
because it returns value in bit like 0 and 1.
Example
CREATE BITMAP JOIN INDEX <index_name>
ON <table_name> (<table_name.column_name>)
FROM <table_name, table_name>
WHERE <join_condition>
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kamala k n
bit map index created on low cardinality columns
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain 1st, 2nd, 3rd normalization form of data base
What is a read write transaction in oracle?
Can we protect our pl/sql source code?
3. Display all the client numbers in the ORDER table. Remove duplicates.
how the indexes are stored in the Oracle Database?
What are the different types of partitions in oracle?
What is the exact use of Collections?
What is the difference between translate and replace?
What is recovery manager in Oracle?
How to get a list of all background sessions in the database?
What is OCI. What are its uses?
how to retrieve data from different tables ,place this data in different excel worksheets.
Oracle General 
