The speed of the join statement-CodePudding

Excuse me, what is the difference between the following two SQL speed?

First write the join condition on the back, the second is to put the join table where screening is done first,

If there are millions of data quantity, could you tell me which kind of join writing faster??

- my edit
Select top (10) * from [Production] [ProductDocument] doc
Join [Production] [Product] pt on doc. ProductID=pt. ProductID
And pt ProductID!=317

- my edit2
Select top (10) * from [Production] [ProductDocument] doc
The join (select * from [Production] [Product] where ProductID! Pt
=317)On doc. ProductID=pt. ProductID

CodePudding user response:

First,
But the high son is a dwarf

CodePudding user response:

 https://baike.baidu.com/item/SARG/10337663? Fr=Aladdin

This is not operator SARG principle, high efficiency is the,