which is better? Putting condition in inner join or where clause?

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  March 31, 2006 at 12:56 pm

  #112318

  Hi,

  I have a question relating to the performance of the query. which one will run faster in the following queries. If so, why?

  SELECT A.productid, B.productdescription

  FROM table A JOIN table B

  ON A.productid = B.productid AND B.Active = 1

  or

  SELECT A.productid, B.productdescription

  FROM table A JOIN table B

  ON A.productid = B.productid

  where B.Active = 1

  Thanks,

  Sridhar.

• kevin mann

  Hall of Fame

  Points: 3894

  More actions

  March 31, 2006 at 1:06 pm

  #630226

  they are the same. ON just gets higher precedence.

• chandra pottipati

  SSC Veteran

  Points: 292

  More actions

  March 31, 2006 at 1:09 pm

  #630228

  There is a whole tread dedicated on this topic on http://www.sql-server-performance.com

  http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11585

   

• chandra pottipati

  SSC Veteran

  Points: 292

  More actions

  March 31, 2006 at 1:13 pm

  #630230

  http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11585

  Comments posted by Frank Kalis on the order of execution of the FROM and WHERE clause gives insite into the query execution process.