Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 7059 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 the different normalization forms?
What is the sql query to concatenate column values from multiple rows in oracle?
Which is better Oracle or MS SQL? Why?
What is the difference between primary key and unique key and foreign key in oracle?
How to assign query results to variables?
What are the various oracle database objects?
How to define and use table alias names in oracle?
What is an oracle data file?
What are the ways tablespaces can be managed and how do they differ?
How to connect asp pages to oracle servers?
What is a read write transaction in oracle?
what is difference between cartesian join & cross join even they give same result?
Oracle General 
