Answer Posted / 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 |
Post New Answer View All Answers
What is a lookup table in oracle?
what is Single Byte Overhead...?
How can I combine multiple rows into a comma-delimited list in oracle?
What are named parameters?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What happens if variable names collide with table/column names?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Is insert autocommit in oracle?
How to create a new tablespace in oracle?
What is meant by recursive hints in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to drop an existing view in oracle?
What are the original export and import utilities?
What is tns entry?
Point the difference between translate and replace?