Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 6940 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 |
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How many types of tables are there in oracle?
What is the difference between post-database commit and post-form commit?
What happens if the update subquery returns multiple rows?
what is the difference between table and veiw?
How to add another datafile to a tablespace?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
what are the different types of cursors? explain?
definition of cluster and non-clustered index?
what is insert all statement in sql
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is recovery manager(rman) backup in Oracle?
Oracle General 
