Which is true of a Storage Index in the Oracle Exadata Database Machine?

The correct answer is A. Stores minimum and maximum values for a 1 MB region. 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…

Smart Scan Technology

Question

Options

AStores minimum and maximum values for a 1 MB region
BCan be used to eliminate cells from queries
CIs a standard database index
DPersists through a cell reboot

How the community answered

(43 responses)

A
72% (31)
B
7% (3)
C
5% (2)
D
16% (7)

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

Topics

#Storage Index#min/max region values#cell elimination#Smart Scan

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice