Which two are regarding the case of storage indexes?

Which two are regarding the case of storage indexes?

Which two are regarding the case of storage indexes?

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.

C.
The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each
storage server.

D.
Storage indexes are retained after a cell is rebooted.

E.
Avoid the use of bind variables because Storage Indexes do not work with bind variables.

Explanation:
B:* 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.
Incorrect:

Not D:Storage indexes reside in the memory of the storage servers.
If a storage cell is shutdown or rebooted the storage index will be lost from memory and will be
recreated on subsequent accesses to the data after the cell has been brought back online.



Leave a Reply 10

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


sugar

sugar

Not E: Storage indexes work with bind variables.

Sudhakar Marampelly

Sudhakar Marampelly

It should be A (Invisible Index) and B (load data on filtered columns)

Sanjay Mevada

Sanjay Mevada

It’s 100% sure that B is correct, D and E are incorrect.
Need to find out which one is correct between A and C.

Syed Jaffer Hussain

Syed Jaffer Hussain

The correct answers are B & E.

Syed Jaffer Hussain

Syed Jaffer Hussain

correction to previous response. The correct answer is A & B.