Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 6961 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 |
WHT ARE THE AGGREATE FUNCTIONS?
How to increment dates by 1 in oracle?
How are extents allocated to a segment?
how to we delete a row using varray
Can we create trigger on view in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to define an external table with a text file?
What is a user role in oracle?
What are the general rules on data consistency?
What do you mean by merge in oracle and how can we merge two tables?
How to use "startup" command to start default instance?
What is execute immediate in oracle?
Oracle General 
