Friday, March 26, 2010
What are the steps you will take to improve performance of a poor performing query?
Some general issues that you could talk about would be: No indexes, excess recompilations of stored procedures, procedures and triggers , poorly written query with unnecessarily complicated joins, too much normalization, excess usage of cursors and temporary tables.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment