You plan to migrate an existing production database supporting online transaction processing (OLTP)
workloads to an X6 Exadata Database Machine.
The database currently supports an application requiring fast response times to satisfy stringent business
requirements, and most of the application queries use indexed access to tables.
For which two cases would you consider dropping indexes that are not used for constraints after the migration
to assure that Smart Scans occur?
A.
if Smart Scan performs better that any type of index scan on the corresponding table.
B.
if Smart only occur instead of index skip scans on the corresponding table.
C.
if Smart only occur instead of index range scans on the corresponding table.
D.
if Smart Scans performs equally well to any type of index scan on the corresponding table.
Explanation: