Which is true of a Storage Index in the Oracle Exadata Database Machine?
A.
Stores minimum and maximum values for a 1 MB region
B.
Can be used to eliminate cells from queries
C.
Is a standard database index
D.
Persists through a cell reboot
Explanation:
In Oracle Database 11gR2 a new feature called the Exadata Storage Index has
been introduced. The storage index contains a summary of the data distribution on the disk and
provides an additional method to eliminate unnecessary disk IO.Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions
(default 1MB). There is an index entry for every storage region (1MB of data stored on disk). Each
entry contains the minimum and maximum value for columns seen in ‘where’ clause predicates.
http://kerryosborne.oracle-guy.com/2010/08/oracle-exadata-storage-indexes/