View the Exhibit1 and examine the structure and indexes for the MYSALES table.
The application uses the MYSALES table to insert sales record. But this table is also extensively used for generating sales reports. The PROD_ID and CUST_ID columns are frequently used in the WHERE clause of the queries. These columns are frequently used in WHERE clause of the queries. These columns have few distinct values relative to the total number of rows in the table.
View exhibit 2 and examine one of the queries and its auto trace output.
What should you do to improve the performance of the query?
30_1 (exhibit):
30_2 (exhibit):
A. Use the INDEX_COMBINE hint in the query.
B. Create composite index involving the CUST_ID and PROD_ID columns.
C. Gather histograms statistics for the CUST_ID and PROD_ID columns.
D. Gather index statistics for the MYSALES_PRODID_IDX and MYSALES_CUSTID_IDX indexes.
|
Download Printable PDF. VALID exam to help you PASS. |
 |