1Z0-117 · Question #6
View 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…
The correct answer is B. Use the INDEX_COMBINE hint in the query. C. Create a composite index involving the CUST_ID and PROD_ID columns. B: The INDEX hint explicitly chooses an index scan for the specified table. You can use the INDEX hint for domain, B-tree, bitmap, and bitmap join indexes. However, Oracle recommends using INDEX_COMBINE rather than INDEX for the combination of multiple indexes, because it is a…
Question
View 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 have few distinct values relative to the total number of rows in the table. The MYSALES table has 4.5 million rows. View exhibit 2 and examine one of the queries and its autotrace output. Which two methods can examine one of the queries and its autotrace output?
Exhibits
Options
- ADrop the current standard balanced B* Tree indexes on the CUST_ID and PROD_ID columns and re-create
- BUse the INDEX_COMBINE hint in the query.
- CCreate a composite index involving the CUST_ID and PROD_ID columns.
- DRebuild the index to rearrange the index blocks to have more rows per block by decreasing the value for
- ECollect histogram statistics for the CUST_ID and PROD_ID columns.
How the community answered
(37 responses)- A3% (1)
- B78% (29)
- D14% (5)
- E5% (2)
Explanation
B: The INDEX hint explicitly chooses an index scan for the specified table. You can use the INDEX hint for domain, B-tree, bitmap, and bitmap join indexes. However, Oracle recommends using INDEX_COMBINE rather than INDEX for the combination of multiple indexes, because it is a more versatile hint. C: Combining the CUST_ID and PROD_ID columns into an composite index would improve
Topics
Community Discussion
No community discussion yet for this question.