Interview Question

Vice President Interview

How to improve SQL performance?

Answer

Interview Answer

2 Answers

0

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
0

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