Practise the standard verbs for creating indexes and inspecting query plans.
0 / 5 completed
1 / 5
Fill in: 'We ___ a composite index to speed up the slow report query.'
We 'create an index' — the standard database collocation for adding a new index. 'Make up', 'build off' and 'form round' are not idiomatic here.
2 / 5
Fill in: 'Unused indexes ___ write performance without helping reads.'
We 'degrade performance' — the standard collocation for something reducing efficiency. The other options aren't idiomatic verbs in this context.
3 / 5
Fill in: 'The query planner will ___ the index if the statistics are stale.'
We 'ignore the index' — the standard collocation for a planner choosing not to use it. The other options are awkward phrasings here.
4 / 5
Fill in: 'We ___ query plans to confirm the new index is actually used.'
We 'inspect query plans' — the standard collocation for examining execution details. The other options are informal or non-idiomatic here.
5 / 5
Fill in: 'A poorly chosen index can ___ table bloat over time.'
We 'cause bloat' — the standard collocation for something producing an unwanted side effect. The other options don't collocate idiomatically with bloat.