SQL Server Performance

What to look for in Execution plans when a query is very slow

Discussion in 'ALL SQL SERVER QUESTIONS' started by Frank.svs, Dec 20, 2013.

  1. Frank.svs New Member

    Hi Everyone,

    Seeking help on below .

    Assuming the query execution is slow , I have collected the actual execution plan. What should I look for in the actual execution plan . What are the top 10 things I need to watch out for?

    I know this is a broad and generic question but I am looking for anyone who is experienced in query tuning to answer this question.

    Thanks in Advance.
  2. AJITH123 Member

    idealy you need to look where it consume more time..check the sufficient index in the table ..check the query is using the correct plan..and a lot

Share This Page