Which three options would improve the performance of th…

Examine the parameter values configured in your database:
sga_max_size = 480M sga_target = 480M pga_aggregate_target = 160M
TheCUSTOMERStable contains 8,000 rows. TheCUST_IDcolumn is the primary key and
theCOUNTRY_IDcolumn contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(‘SH’,‘CUSTOMERS’);
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform severalINSERT, UPDATE, andDELETEoperations, significantly altering
the data in the table.
View theExhibit to examine the query and its execution plan.

Which three options would improve the performance of the query?(Choose three.)

A.
creating a bitmap index on theCOUNTRY_IDcolumn

B.
regathering statistics on theCUSTOMERStable

C.
creating a histogram on theCOUNTRY_IDcolumn

D.
increasing the size of the PGA

E.
creating an SQL profile

F.
creating aKEEPcache