What are the steps you will take to improve performance of a poor performing query?
This is a very open ended question and there could be a lot of reasons behind the poor performance of a query. But some general issues that you could talk about would be: No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers without SET NOCOUNT ON, poorly written query with unnecessarily complicated joins, too much normalization, excess usage of cursors and temporary tables.
Related Questions
- Prior to terminating a Staff Member for poor performance do I have to go through the steps of giving the Staff Member a documented oral warning, written warning and final written warning?
- I am getting really poor performance out of my network, especially when talking to older networks or when performing short file transfers. Whats the problem?
- What are the steps you will take to improve performance of a poor performing query?
