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
Can multiple cursors being opened at the same time?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the order of defining local variables and sub procedures/functions?
How many categories of data types?
Difference between pre-select and pre-query
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to define a variable of a specific record type?
How to unlock the sample user account in oracle?
Explain mutating triggers.
How to display employee records who gets more salary than the average salary in the department?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Explain the use of parfile option in exp command.
Can we create trigger on materialized view in oracle?