Goldman Sachs Interview Question

How to improve SQL performance?

Interview Answers

Anonymous

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

May 13, 2011

Locking patterns Query join optimization