National_Instruments
200-500 · Question #162
Which technique should be used to speed up joins without changing their results?
The correct answer is A. Add indices on joined columns. See the full explanation below for the reasoning.
Question
Which technique should be used to speed up joins without changing their results?
Options
- AAdd indices on joined columns
- BAdd a WHERE clause
- CAdd a LIMIT clause
- DUse an inner join
How the community answered
(63 responses)- A75% (47)
- B16% (10)
- C6% (4)
- D3% (2)
Community Discussion
No community discussion yet for this question.