A query against the system catalog revealed that data for a table named SALES in a partitioned
database is distributed as follows:

What can be done to improve the performance of a query that joins SALES and DATE_DIM tables
(where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

A.
Reload table SALES and use only one partition with a collocated join to the DATE_DIM table
using the primary key DATE_ID.

B.
Reload table DATE_DIM and use only one partition with a collocated join to the SALES table
using the primary key DATE_ID.

C.
Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table,
create index on DATE_ID column in theREPL_SALES table, and collect statistics on
REPL_SALES table.

D.
Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh
REPL_DATE_DIM table, create index on DATE_ID column in theREPL_DATE_DIM table, and
collect statistics on REPL_DATE_DIM table.

Explanation: