By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even
though an index exists. In order to utilize the existing index, what should be done before issuing the
RUNSTATS command to collect statistics for both the index and table?
A.
Drop and reload the table.
B.
Drop and recreate the index.
C.
Reorganize the table to cluster its data according to that index.
D.
Reorganize the table to cluster its index according to that query plan.