what is the bitmap index?
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 use of composite key constraint?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Is a rollback possible to any savepoint?
In Oracle 9i what does "i" Stands for?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What is the difference between alert log file and tarce file ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How do I call oracle stored procedures that take no parameters?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to turn on or off recycle bin for the session?
What is program global area (pga) in oracle?
What is meant by joins? List out the types of joins.