Showing posts with label What are the steps you will take to improve performance of a poor performing query?. Show all posts
Showing posts with label What are the steps you will take to improve performance of a poor performing query?. Show all posts
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:
Posts (Atom)