Which two are regarding the case of storage indexes?

The correct answer is A. To increase the chance of using the a storage index, you can make table indexes invisible. B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns. To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. * With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within…

Key Capabilities and Features

Question

Options

ATo increase the chance of using the a storage index, you can make table indexes invisible.
BTo maximize the benefit of storage Indexes, load your data stored on the filtered columns.
CThe cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each
DStorage indexes are retained after a cell is rebooted.
EAvoid the use of bind variables because Storage Indexes do not work with bind variables.

How the community answered

(23 responses)

A
70% (16)
C
9% (2)
D
17% (4)
E
4% (1)

Explanation

To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. * With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.

Topics

#storage indexes#bind variables#cell optimization#data loading

Community Discussion

No community discussion yet for this question.

Full 1Z0-027 Practice