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

SQL statement tuning centers on optimization quality - whether the query optimizer finds an efficient execution plan. The number of CPUs (A) and degree of parallelism (B) are system resources, not tuning considerations. Bitmap indexes (C) are specific access methods, not general tuning principles. Optimization quality directly affects performance.

Keep practicing — related questions