Oracle
1Z0-873 · Question #66
Suppose you want queries that are not using indexes to be logged to the slow log. How would you enable this?
The correct answer is C. Use the --log-queries-not-using-indexes option. To log queries that are not processed with the benefit of indexes, use the --log-queries-not-using-
MySQL Logging
Question
Suppose you want queries that are not using indexes to be logged to the slow log. How would you enable this?
Options
- AUse the --log-queries-indexes option.
- BUse the --log-slow-queries-indexes option.
- CUse the --log-queries-not-using-indexes option.
- DUse the --log-slow-queries-not-using-indexes option.
How the community answered
(43 responses)- A2% (1)
- B5% (2)
- C79% (34)
- D14% (6)
Explanation
To log queries that are not processed with the benefit of indexes, use the --log-queries-not-using-
Topics
#slow query log#index logging#query optimization#server options
Community Discussion
No community discussion yet for this question.