which index type is most likely to be used to improve the performance of some queries where the data is of low cardinality?

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?

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Google

Google

Just beneath, are many totally not related internet sites to ours, even so, they are surely worth going over.

Google

Google

Just beneath, are various entirely not associated web pages to ours, on the other hand, they’re certainly really worth going over.

slot machine book fra

slot machine book fra

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