Home » Oracle » 1z0-027 » 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.
Correct Answer: AB
Explanation/Reference:
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.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
