Pergunta de entrevista da empresa Essendant

How do you preform a search in SQL? Why not use 'index'?

Resposta da entrevista

Sigiloso

5 de nov. de 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