Multiple choice technology databases

Which of the following is an important consideration when tuning an SQL statement

  1. The number of CPUs on the server

  2. The degree of parallelism on the tables

  3. The use of bitmap indexes

  4. The quality of the SQL optimization
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The quality of the SQL optimizer is critical because it chooses the access paths and execution plans. While hardware factors (like CPUs) and physical schema choices (parallelism, indexes) matter, the optimizer's decisions directly determine the runtime efficiency of the query.

Keep practicing — related questions