Multiple choice

Which of the following is true about the SQL Tuning Advisor?

  1. It automatically collects statistics if they are missing

  2. It only makes recommendations to collect statistics

  3. It ignores optimizer statistics completely

  4. It uses only the available statistics
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL Tuning Advisor is an Oracle tool that analyzes SQL statements and provides recommendations for performance improvement, including automatically collecting missing optimizer statistics when needed. While it can recommend statistics collection (option B), it can also proactively collect them. Option C is incorrect because the advisor heavily relies on optimizer statistics for analysis. Option D is incomplete because the advisor will collect missing statistics rather than work with incomplete data.

Keep practicing — related questions