Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 6959 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 pragma?
What does `(+)` do in a where clause?
How to insert a record into a table?
What is the maximum number of triggers that can be applied to a single table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is an oracle data file?
What is a sub query and what are the different types of subqueries?
What is set operator oracle?
What are the differences between char and nchar in oracle?
What is oracle open database communication (odbc)?
What is a package ? What are the advantages of package ?
Write a syntax for update query in oracle?
Oracle General 
