You will be implementing a data warehouse for one of your customers. In your design process,
which index type is most likely to be used to improve the performance of some queries where the
data is of low cardinality?
A.
Bitmap indexes
B.
B*-tree indexes
C.
Reverse indexes
D.
Invisible indexes
Explanation:
Bitmap indexes are a highly compressed index type that tends to be used primarily
for data warehouses.
Characteristic of Bitmap Indexes
* For columns with very few unique values (low cardinality)
* Columns that have low cardinality are good candidates (if the cardinality of a column is <= 0.1 %
that the column is ideal candidate, consider also 0.2% 1%)
* Tables that have no or little insert/update are good candidates (static data in warehouse)
* Stream of bits: each bit relates to a column value in a single row of table
Reference: The Secrets of Oracle Bitmap Indexes,http://www.akadia.com/services/ora_bitmapped_index.html
A
all low-cardinality columns (there are only three possible values for marital status, two possible values for gender, and 12 for income level), bitmap indexes are ideal for these columns
https://docs.oracle.com/cd/E11882_01/server.112/e25554/indexes.htm#DWHSG006
Just beneath, are many totally not related internet sites to ours, even so, they are surely worth going over.
Just beneath, are various entirely not associated web pages to ours, on the other hand, they’re certainly really worth going over.
Wonderful story, reckoned we could combine some unrelated data, nevertheless genuinely worth taking a search, whoa did one understand about Mid East has got much more problerms at the same time