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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Performance. 2
Query help - modify SQL to get records 2
Hi........ very urgent join question 2
Trying to remove duplicate field1 1
Optimizing join queries with indexes. 1
Left Join to Huge Table with Duplicates 1
Aliasing JOINs 2
Top X from joined table 1

Back
Top