Faster of the 2 Inner join or Outer join

• Low Rider

  SSCommitted

  Points: 1502

  More actions

  December 10, 2007 at 1:32 am

  #119862

  Hi can anyone tell me if there is a diffrence in the performance for a inner join query and a outer join query.ie which is faster inner or outer join.

  thanks

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  December 10, 2007 at 1:37 am

  #758500

  Hi

  Mostly it would be the inner join since it needs to fetch lesser number of rows when compared to a outer join.

  "Keep Trying"

• Ananth-431739

  Ten Centuries

  Points: 1185

  More actions

  December 11, 2007 at 5:36 am

  #758900

  Inner Join will be faster.