Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Not In and/or <> and /or !=
"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