Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 6887 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 data type in oracle?
What is bind variable in oracle 11g?
How to shutdown your 10g xe server?
What do you mean by group by clause?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
what are different types of deletes?
what are corelated subqueries
Explain the use of record length option in exp command.
Explain what are the uses of rollback segment?
what are the advantages of running a database in archive log mode?
Does rowid change in oracle?
How to pass parameters to procedures?
Oracle General 
