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

From: vegas_girlie <minnie_valerie_at_hotmail.com>
Date: 8 May 2005 23:34:31 -0700
Message-ID: <1115620471.818200.178550@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? Received on Mon May 09 2005 - 01:34:31 CDT