Zend
200-710 · 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.
Databases & SQL
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
(54 responses)- A76% (41)
- B4% (2)
- C13% (7)
- D7% (4)
Topics
#SQL joins#database indices#query optimization#performance
Community Discussion
No community discussion yet for this question.