nerdexam
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)
  • A
    2% (1)
  • B
    5% (2)
  • C
    79% (34)
  • D
    14% (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.

Full 1Z0-873 Practice