SQLTeam.com | Weblogs | Forums

Execution plan - explanation

Hello everyone,

I'm trying to improve a particular query, and do some check on the Query Execution plan and see Two main Operators:

  • Index scan (Nonclustered) - Cost 39%
  • Hash Match Right outer Join - Cost 31%

What does it actually mean, and how can I improve it?

Thanks (:

I have no idea without seeing the actual query.

It's possible an index scan is the best method, it's possible it's terrible for performance, no way to know without seeing the query. Also need the DDL for the table, including all its indexes.