what is the bitmap index?
- 3 Answers
- 5972 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 |
What is the difference between translate and replace?
Give the various rollback segment states.
Why should I use oracle database?
How to concatenate two text values in oracle?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
How do I spool in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to enter a new row into a table interactively?
Explain cascading triggers.
What is Redo Log Buffer in Oracle?
How to invoke the data pump import utility?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
Oracle General 
