Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 6796 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 |
Why we choose emp number as primarykey?
Is there an oracle sql query that aggregates multiple rows into one row?
What is COST-based approach to optimization ?
What is meant by an index?
What is difference between SUBSTR and INSTR?
How to return top 5 rows in oracle?
Name the various constraints used in oracle?
Explain oracle’s system global area (sga).
How can you use check constraints for self referential integrity?
What is an oracle user account?
What happens if the imported table already exists?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Oracle General 
