Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Query Question (Performance) CORRECTION
> (CORRECTION TO THE SECOND QUERY, CUT AND PASTE ERROR]
>
> Given a table structure, (with sample data),
>
> INVOICE
> =======
> ID COL1 COL2
> 1 aaaa aaaa
> 2 bbbb bbbb
> 2 cccc cccc
>
> JOIN_TABLE
> ==========
> CUST_ID INVOICE_ID
> 1 1
> 1 2
> 1 3
>
> I was wondering if somebody could tell me which is more efficent, or a
> possible 3rd
> more efficent query, of the below:
>
> SELECT
> INVOICE.OID,
> INVOICE.COL1,
> INVOICE.COL2,
> INVOICE.COL3
> FROM INVOICE WHERE INVOICE.OID IN
> (SELECT
> JOIN_TABLE.INVOICE_ID
> FROM JOIN_TABLE
> WHERE
> JOIN_TABLE.CUST_ID = '1');
>
>
> SELECT
> DISTINCT
> INVOICE.OID,
> INVOICE.COL1,
> INVOICE.COL2,
> INVOICE.COL3
> FROM INVOICE, JOIN_TABLE
> WHERE
> JOIN_TABLE.CUST_ID='1'
> AND
> JOIN_TABLE.INVOICE_ID = INVOICE.OID;
>
> Thanks in advace
>
> ....Seán
>
Received on Tue Jul 01 1997 - 00:00:00 CDT