Hi all

I have a particular scenario and I wanted to know if the table I specify in the FROM will have any affect on performance, take this example:

Table1 - 200,000 records
Table2 - 17,000 records

Table1 can have 0 or 1 records in Table2.

Will this:

select *
from Table1
inner join Table2
on Table1.PK = Table2.FK

perform worse than this:

select *
from Table2
inner join Table1
on Table2.FK = Table1.PK

Just curious, given that Table1 has more records than Table2 - will the above queries result in different performance?

Thanks
Kev