Interview Question

Vice President Interview

How to improve SQL performance?


Interview Answer

2 Answers


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.

David Fetter on May 5, 2011

Locking patterns
Query join optimization

Anonymous on May 13, 2011

Add Answers or Comments

To comment on this question, Sign In with Facebook or Sign Up