Multiple choice

When is the best time to tune a database application?

  1. At design time

  2. At development time

  3. Before going live

  4. When problems are experienced

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Tuning at design time is most cost-effective and efficient. Design-time tuning prevents performance issues before code is written, avoids expensive rework later, and establishes proper architecture, indexing strategies, and access patterns from the start.