Which of the following is an important consideration when tuning an SQL statement?
-
The number of CPUs on the server
-
The degree of parallelism on the tables
-
The quality of the SQL optimization
-
The use of bitmap indexes
SQL statement tuning focuses on writing efficient queries that the optimizer can execute effectively. The quality of SQL optimization (how well the query is structured and how efficiently it uses indexes) directly impacts execution time. While server resources like CPUs and parallelism settings affect overall performance, they are database configuration considerations rather than statement-level tuning concerns.
'The quality of the SQL optimization' is correct because how well the optimizer chooses an execution plan (join order, access paths, index usage) has the most direct and controllable impact on statement performance. The number of CPUs is a hardware/infrastructure factor outside the statement itself; degree of parallelism only matters once a plan is chosen and is a secondary tuning lever; bitmap indexes are just one specific technique that may or may not apply. Tuning fundamentally means improving the optimizer's plan quality (via stats, hints, rewriting), making it the central consideration among these options.