sql server - SQL: "Where" or "AND" what performs better on large database? -

This question is already an answer here

• 10 answers

The query is about. It runs on a single table and creates a dataset with three columns. My concern is that I should use the 'WHERE' segment or 'AND' or not, I am feeling that 'and' will be more efficient and faster than 'WHERE', please advise. 1 is with 'WHERE' and 2 is also without it.

1. DISTINCT t1.rpsrespondent ID_NUM, as t1.rpscontent PID, select t2.RpsContent as SeqNo
   T1 on table T1 interiors. Rpsrespondent = t2.rpsrespondent table join t2 join t3.rpsrespondent = t1.rpsrespondent table t3 interiors where t1.RpsQuestion = 'PID' and t2.RpsQuestion = 'visitId' and t3.rpsquestion = 'INT99' and t3.rpscontent In the form of SeqNo as selected ('36 ',' 37 ')

2. DISTINCT t1.rpsrespondent as ID_NUM, t1.rpscontent PID, t2.RpsContent < Br> Join table T1 to INNER table T2 t1.rpsrespondent = t2.rpsrespondent and t1.rp S Question = 'PID' and T2 RPS Question = 'VisitId' Join Inner T3 on Table T3 RSSSPnet = T1. RSsportant and T3 After the text "itemprop =" in RPCision = 'INT99' and 't3.rpscontent' ('36', '37')

JOIN or WHERE sections, if there is a inner join with no text Queries are semantically similar so that the SQL Server Optimizer should generate the same (optimal) execution plan. You will get the same performance as a result.