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
Query to retrieve record for a many to many relationship ?
What is a subquery?
How to create a table in a specific tablespace?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How does oracle handle read consistency?
How to create a new tablespace in oracle?
What is recycle bin in Oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is max rowid in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to check the server version in oracle?
List out the components of logical database structure of oracle database.
State any two functions of oracle?
How to write a query with an inner join in oracle?
What is a synonym? What are its various types?