Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie : Where ... part ?

Re: Newbie : Where ... part ?

From: frank <fbortel_at_home.nl>
Date: Thu, 19 Oct 2000 18:50:46 GMT
Message-ID: <39EF42CB.DC719F1A@home.nl>

porting Proceed to Oracle?

S van Hoof wrote:

> 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
> ?
Received on Thu Oct 19 2000 - 13:50:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US