IBM
C2090-312 · Question #114
C2090-312 Question #114: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.
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.
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.