User Id :    Password :      New Member   Forgot Password  
Topic: What are the steps you will take to improve performance of a poor performing query
Sachin Jain
30 Oct 2010 at 02:52 AM
What are the steps you will take to improve performance of a poor performing query?
Re: What are the steps you will take to improve performance of a poor performing query
Gaurav
31 Oct 2010 at 10:45 PM
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.
Total Replies: 1
 
Featured Text Ad

Featured Ad