Multiple choice

In _______, the bottom up approach is used to find and fix the bottlenecks.

  1. proactive tuning

  2. reactive tuning

  3. active tuning

  4. sql tuning
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL tuning uses a bottom-up approach by examining individual SQL statements and their execution plans to identify and fix bottlenecks. Proactive tuning is top-down (system-wide), reactive tuning responds to problems, and 'active tuning' isn't a standard term. SQL tuning is methodical and statement-focused.

Keep practicing — related questions