IBM
C2010-501 · Question #128
In which case would indexing a table fail to fix an inefficient query?
The correct answer is C. When the WHERE clause includes a leading wildcard character. See the full explanation below for the reasoning.
Question
In which case would indexing a table fail to fix an inefficient query?
Options
- AWhen the WHERE clause is used on a Long Description.
- BWhen the WHERE clause has more than eight nested queries.
- CWhen the WHERE clause includes a leading wildcard character.
- DWhen the WHERE clause is used in Maximo Integration Framework.
How the community answered
(36 responses)- A14% (5)
- B3% (1)
- C78% (28)
- D6% (2)
Community Discussion
No community discussion yet for this question.