1 / 5
Adding an index helps ___ query performance significantly.
-
-
-
-
To improve performance means to make queries faster. Improve is the standard collocation; the distractors are informal.
2 / 5
We ___ the execution plan to find the slow part of the query.
-
-
-
-
To analyze a plan means to examine it carefully. Analyze is the precise verb; the others do not collocate well.
3 / 5
A missing index can cause a full table ___.
-
-
-
-
A table scan is the fixed term for reading every row. Scan is the correct collocation; the others are near-synonyms that do not collocate.
4 / 5
We ___ the query to avoid fetching unnecessary columns.
-
-
-
-
To rewrite a query means to restructure it for efficiency. Rewrite is the natural verb; the distractors are casual.
5 / 5
Optimizers ___ an index when it speeds up access.
-
-
-
-
To leverage an index means to take advantage of it. Leverage is the idiomatic collocation; the others are wrong.