Essendant
Part of Sycamore Partners
Engaged employer
Essendant interview question
How do you preform a search in SQL? Why not use 'index'?
Interview Answer
Anonymous
5 Nov 2017
A programmer can use the SQL WHERE clause in order to preform a search. The main reason a programmer will not use 'index' is due to denormalization where performance will improve on the expense of adding redundant copies of data.
1