CompTIA Data+ (DA0-001) — Question 265

Which of the following query optimization techniques is the best way for an analyst to make the query execute faster?

Answer options

• A. Indexing
• B. Parametrizing
• C. Windowing
• D. Caching

Correct answer: A

Explanation

Indexing is the most effective technique for speeding up query execution as it allows the database to quickly locate and access the required data. The other options, while useful in different contexts, do not primarily focus on enhancing execution speed in the same way that indexing does.