Pergunta de entrevista da empresa Goldman Sachs

How to improve SQL performance?

Respostas da entrevista

Sigiloso

5 de mai. de 2011

Make sure the tables are normalized to the appropriate degree, then that they're indexed correctly. Those are foundational. From there, improvements can normally only come in the 5-10% range.

Sigiloso

13 de mai. de 2011

Locking patterns Query join optimization