sql query

Hi,

The below SQL statement is what my program is trying to execute:

Each table abt 2 million rows.
All fields that are joined/queried on are INDEXED. We verified that.

This took > 3 hours to execute & it is not completed yet  when my Telnet session timed-out

Previously this query executed in less than half an hour in the MainFrame.

Any clue on why Oracle is doing so slowly ?

Thanks evelyn.

SELECT DISTINCT count(*)
FROM tb_EASY_HOUSE, tb_EASY_RE
WHERE (
(tb_EASY_HOUSE.STREET_CODE=tb_EASY_RE.STREET_CODE OR

        (tb_EASY_HOUSE.STREET_CODE IS NULL AND tb_EASY_RE.STREET_CODE IS NULL) ) AND
(tb_EASY_HOUSE.BLOCK=tb_EASY_RE.BLOCK OR

        (tb_EASY_HOUSE.BLOCK IS NULL AND tb_EASY_RE.BLOCK IS NULL) ) AND
(tb_EASY_HOUSE.MAIN_HSE=tb_EASY_RE.MAIN_HSE OR

        (tb_EASY_HOUSE.MAIN_HSE IS NULL AND tb_EASY_RE.MAIN_HSE IS NULL) ) AND
(tb_EASY_HOUSE.SUB_HSE=tb_EASY_RE.SUB_HSE OR

        (tb_EASY_HOUSE.SUB_HSE IS NULL AND tb_EASY_RE.SUB_HSE IS NULL) ) );

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 05 1999 - 05:35:32 CDT