Bitmap index is suitable for the tables having huge and repeatative(duplicates) data.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- BITMAP INDEX is used in situations where the index is created after the table or partition is populated ?
- bitmap index should be created on columns which have high cardinality
- When creating an index using the CREATE INDEX statement,the UNIQUE and BITMAP keywords may be used together.
- Which index is best suited in case of a table having redundant data
- If the value in a column is not unique then which index is used ?
- Which is the Defualt Index ?
- A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decre...
- Which of the following are the restrictions of creating bitmap indexes (choose all that apply):