SQL Server Performance

Help resolve query plan

Discussion in 'ALL SQL SERVER QUESTIONS' started by gkochkin, Jun 26, 2014.

  1. gkochkin New Member

    Here is the plan for the query. It looks to me very well .But the query execution time is about 10-15 minutes ...
    Please help to get an idea of what's going on

    Attached Files:

  2. davidfarr Member

    The execution plan on it's own does not contain enough information to know exactly where the problem is. It is not even certain that there is a problem at all. For large queries it may be normal to have a 10-15 minute execution time. It does however show that your ORDER clause is the most intensive part.

    How many rows are returned in the result ? How many rows are in the source objects ?
    What columns are you selecting and what data types are they ? (For example image or binary columns would perform poorly). On what column do you ORDER by and is that column indexed (clustered or nonclustered) ?

Share This Page