IBM
C2010-530 · Question #51
A company's users are seeing slow performance when opening the Work Order Tracking application. After some investigation it is determined that the default query is doing a full table scan. How can…
The correct answer is A. Verify default table indexes exist. See the full explanation below for the reasoning.
Question
A company's users are seeing slow performance when opening the Work Order Tracking application. After some investigation it is determined that the default query is doing a full table scan. How can this be prevented?
Options
- AVerify default table indexes exist.
- BVerify columns in the SQL statement WHERE clause are not indexed.
- CVerify no leading wildcard character in the SQL statement WHERE clause.
- DVerify the Maximo user executing the SQL statement has query rights to the table.
How the community answered
(30 responses)- A73% (22)
- B7% (2)
- C3% (1)
- D17% (5)
Community Discussion
No community discussion yet for this question.