IBM
C2090-461 · Question #16
When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing…
The correct answer is A. The wrong index was chosen for the Optim Primary Key for the table. See the full explanation below for the reasoning.
Question
When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?
Options
- AThe wrong index was chosen for the Optim Primary Key for the table.
- BThe table has a very large amount of data and the database engine has chosen a different
- CYou do not have authority in the database to specify a key to use.
- DCompare Row Contents option was not selected prior to running the Delete Request.
How the community answered
(35 responses)- A83% (29)
- B9% (3)
- C6% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.