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

Home -> Community -> Usenet -> c.d.o.server -> Re: Not In and/or <> and /or !=

Re: Not In and/or <> and /or !=

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Mon, 09 May 2005 14:28:28 GMT
Message-ID: <Xns96514C09194B2SunnySD@68.6.19.6>


"vegas_girlie" <minnie_valerie_at_hotmail.com> wrote in news:1115620471.818200.178550_at_z14g2000cwz.googlegroups.com:

> hi,
> i am trying to extract data out from an oracle server and am having a
> tough time with the most basic sql statement. when i run
>
> SELECT tcof.EML_ADDRESS from
> test.EML_TCOF tcof,
> eml_addr_t a
> where rtrim(tcof.EML_ADDRESS) = a.EML_ADDR
>
> i get returned values. however when i run
>
> SELECT a.EML_ADDRESS from
> test.eml a,
> eml_addr_t b
> where rtrim(a.EML_ADDRESS) <> b.EML_ADDR
>
> the query runs forever. i also tried the != and NOT IN and they all
> run for hours. there are only about 6500 records in the a table and
> the b table contains 30 million records. is it because i dont have any
> indexes on table a?
>
>

SELECT a.EML_ADDRESS from test.eml a

where rtrim(a.EML_ADDRESS) not in ( select b.EML_ADDR from eml_addr_t b);   Received on Mon May 09 2005 - 09:28:28 CDT

Original text of this message

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