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.
Reorganize the table to cluster its index according to that query plan.
B.
Drop and reload the table.
C.
Drop and recreate the index.
D.
Reorganize the table to cluster its data according to that index.