The access path chosen for a query shows a table space scan, when it appears that there is an
index available that would provide a more efficient access path. What situation could have caused
a table space scan to be chosen instead of the index?

A.
Index is created with PCTFREE of zero.

B.
The number of columns in the index is less than four.

C.
RUNSTATS were run when there were no rows in the table.

D.
RUNSTATS were run when there was a million rows in the table.

Explanation: