Which three are true concerning Smart Scans?

Which three are true concerning Smart Scans?

Which three are true concerning Smart Scans?

A.
The decision to perform a Smart Scan is made by the Optimizer.

B.
Smart Scans are only possible during full table scans or fast full index scans.

C.
Smart Scans are possible on Index Organized Tables (IOTs).

D.
Smart Scans always outperform scans that are not offloaded.

E.
Smart Scans are possible on heap organized tables.

F.
Smart Scans are possible on uncompressed B*Tree indexes.



Leave a Reply 0

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