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 -> Newbie : Where ... part ?

Newbie : Where ... part ?

From: S van Hoof <stephan_at_hoof.nl>
Date: Thu, 19 Oct 2000 15:19:11 +0200
Message-ID: <8smsan$iou$1@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
? Received on Thu Oct 19 2000 - 08:19:11 CDT

Original text of this message

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