diffrence between joins

  • Thread starter Thread starter Slaven Bojko
  • Start date Start date
S

Slaven Bojko

Hi!

Which one is better, faster, and can someone please explain me the
diffrence?

a)

.... table1 INNER JOIN table2 ON table1.fieldID = table2.fieldID WHERE
table1.field2> table2.field2

b)

.... table1 INNER JOIN table2 ON (table1.fieldID = table2.fieldID AND
table1.field2> table2.field2)

Thanks!

Regards,

Slaven

(please remove ".makniovo" from e-mail addres if you whish to send me a
e-mail)
 
Hi,


b) should be faster, but with just a little bit of chances, the
optimizer would be able to come with the same execution plan in both cases.
So, since a) keep the design grid "available" and b) does not, I may use
a), for maintenance reasons, NOT FOR SPEED...



Hoping it may help,
Vanderghast, Access MVP
 
Thanks a lot for your answer. I think I'll go for a) for the same reasons...

Regards,

Slaven
 
Back
Top