Goldman Sachs interview question

How to improve SQL performance?

Interview Answers

Anonymous

5 May 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.

Anonymous

13 May 2011

Locking patterns Query join optimization