DA0-001 · Question #506
Which of the following query optimization techniques is the best way for an analyst to make the query execute faster?
The correct answer is A. Indexing. Indexing creates a data structure (like a B-tree) that allows the database engine to locate rows without scanning the entire table, dramatically reducing query execution time - especially for large datasets filtered or joined on indexed columns. Caching (D) speeds up repeated…
Question
Which of the following query optimization techniques is the best way for an analyst to make the query execute faster?
Options
- AIndexing
- BParametrizing
- CWindowing
- DCaching
How the community answered
(35 responses)- A86% (30)
- B3% (1)
- C9% (3)
- D3% (1)
Explanation
Indexing creates a data structure (like a B-tree) that allows the database engine to locate rows without scanning the entire table, dramatically reducing query execution time - especially for large datasets filtered or joined on indexed columns. Caching (D) speeds up repeated identical queries by storing results, but it does not optimize the query itself. Parametrizing (B) improves reusability and security (prevents SQL injection) but does not inherently speed up execution. Windowing (C) refers to window functions for analytical calculations and is a query feature, not an optimization technique.
Topics
Community Discussion
No community discussion yet for this question.