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
How to count duplicated values in a column in oracle?
What happens if the imported table already exists?
How to use "if" statements on multiple conditions?
What are the different types of trigger and explain its various uses and functions?
What is the usage of save points in oracle database?
How to run create database statement?
What is dynamic proxy?
How to retrieve data from an explicit cursor?
How much memory your 10g xe server is using?
In the oracle version 9.3.0.5.0, what does each number shows?
How to start a new transaction in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is the difference between sharding and partitioning?
what is the scenario where you take the database to NoArchivelog mode?