Prev Question
Next Question

You plan to migrate an existing production database supporting online transaction processing
(OLTP) workloads to the Exadata Database Machine. The database currently supports an
application requiring fast response times, which satisfies stringent requirements, and most of the

application queries use index access to the tables in the application schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?

A.
Drop non-constraint indexes if Smart Scan occurs instead of an index access path on the
corresponding table.

B.
Drop non-constraint indexesif Smart Scan performs better than index unique scans on the
corresponding table.

C.
Drop non-constraint indexes if Smart Scan performs better than index range scans on the
corresponding table.

D.
Drop non-constraint Indexes if Smart Scan performs better than any index scans on the
corresponding table.

Prev Question
Next Question

Leave a Reply

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