How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?
A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
B. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely
C. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.
D. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.
|
Download Printable PDF. VALID exam to help you PASS. |
 |