PrepAway - Latest Free Exam Questions & Answers

What are possible reasons?

Access of a base table through an index can be more expensive than a full table scan. What are
possible reasons? Select TWO.

PrepAway - Latest Free Exam Questions & Answers

A.
The index contains the same number of records as the base table.

B.
Additional I/O is needed.

C.
Index row sizes are smaller than base table row sizes.

D.
Blocks in the base might be read more than once.

E.
More rows are being retrieved per physical I/O.


Leave a Reply