SQL Server Performance

Self Join

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Gags, Apr 7, 2009.

  1. Gags New Member

    Are self joins a performance hit. Is it better to break a self join query out using temp tables. If so, how can this be explained from an execution plan.
  2. FrankKalis Moderator

    Welcome to the forum!
    How do you define "Performance hit" please? Are you currently facing some issues? What is the execution plan look like?
    Self-Joins are no performance hit off themselves. Generally speaking, if your logical model suggests that you need a self join,so be it. Then make sure the table is properly indexed. Maybe you can think about having a covering index to speed things up.
  3. gregj New Member

  4. Madhivanan Moderator

    [quote user="gregj"]
    What is your comment?

Share This Page