distinct with <>

From: vegas_girlie <minnie_valerie_at_hotmail.com>
Date: 8 May 2005 23:46:21 -0700
Message-ID: <1115621181.132167.209590@o13g2000cwo.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 distinct tcof.EML_ADDRESS from
test.EML a,
eml_addr_t b
where rtrim(a.EML_ADDRESS) = a.EML_ADDR

i get returned values. however when i run

SELECT distinct 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:46:21 CDT