Oracle
1Z0-883 · Question #12
You want a record of all queries that are not using indexes. How would you achieve this?
The correct answer is C. By enabling the Slow Query Log and using the ?log-queries-not-using-indexes option. See the full explanation below for the reasoning.
Question
You want a record of all queries that are not using indexes. How would you achieve this?
Options
- ABy enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
- BBy enabling the Error Log because not using indexes is an error
- CBy enabling the Slow Query Log and using the ?log-queries-not-using-indexes option
- DBy enabling the Error Log and using the ?log-queries-not-using-indexes option
How the community answered
(55 responses)- A9% (5)
- B4% (2)
- C73% (40)
- D15% (8)
Community Discussion
No community discussion yet for this question.