Re: Newbie : Where ... part ?

S van Hoof <stephan_at_hoof.nl> a écrit dans le message : 8smsan$iou$1_at_news1.xs4all.nl...
> Hi,
>
> Just wondering what to do in building "where.." parts of queries.
>
> Does it matter which table I mention first on left-part of the equation
> (performance)?
>
> For Example.
> Table A = 100.000 rows
> Table B = 100 rows
>
> What is faster:
> .. where A.Id=B.Id
> OR
> ..where B.Id=A.Id
> ?

It doesn't matter but if you use RBO you have to correctly choose your from clause:
from A, B (the smallest at the end).

--
Have a nice day
Michel