1 / 5
Fill in: 'We ___ the query plan before assuming an index will actually be used.'
-
-
-
-
We 'inspect a plan' — the standard collocation for examining it in detail. The other options are less idiomatic here.
2 / 5
Fill in: 'A missing statistics update can ___ the planner into choosing a slow sequential scan.'
-
-
-
-
We say stale stats will 'push' the planner toward a bad choice — the standard collocation here. The other options aren't idiomatic here.
3 / 5
Fill in: 'We ___ a slow query's plan side by side with a fast one to spot the divergence.'
-
-
-
-
We 'compare' plans — the standard, simple collocation for contrasting two executions. The other options are less idiomatic here.
4 / 5
Fill in: 'We ___ an index hint only as a last resort, once the planner is clearly wrong.'
-
-
-
-
We 'add a hint' — the standard, simple collocation for the escape hatch. The other options aren't idiomatic here.
5 / 5
Fill in: 'We ___ query plans in CI so a regression is caught before it reaches production.'
-
-
-
-
We 'capture' plans — the standard collocation for recording them for later comparison. The other options are less idiomatic here.