IBM
C2090-312 · Question #114
The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a…
The correct answer is C. RUNSTATS were run when there were no rows in the table. See the full explanation below for the reasoning.
Question
The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?
Options
- AIndex is created with PCTFREE of zero.
- BThe number of columns in the index is less than four.
- CRUNSTATS were run when there were no rows in the table.
- DRUNSTATS were run when there was a million rows in the table.
How the community answered
(41 responses)- A2% (1)
- B10% (4)
- C83% (34)
- D5% (2)
Community Discussion
No community discussion yet for this question.