Oracle Exam 1Z0-064 Topic 6 Question 35 Discussion

Your database supports a DSS system.

Examine the parameter values configured in your database:

sga_max_size = 480M

sga_target = 480M

pga_aggregate_target = 160M

The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column 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 several INSERT, UPDATE, and DELETE operations, significantly altering the data in the table.

View the Exhibit to examine the query and its execution plan.

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