what is the bitmap index?

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


Please Help Members By Posting Answers For Below Questions

Explain a synonym?

614


How to assign values to data fields in record variables?

592


What is hash cluster in oracle?

609


How can we delete duplicate rows in a table?

574


How to define a cusotmer as a supplier in ORACLE R12

1740






What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

555


What's dateware house and what's clustor with practicle example

1657


What are a query and state the different types of queries and their uses?

524


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1971


What is the relation of a user account and a schema?

625


What is bulk copy or bcp in oracle?

621


What happens to the indexes if a table is recovered?

587


What are the most common interview questions on ETL Testing for experience?

613


How to create a table interactively?

574


How to test null values?

691