From: hpcheong@ncs.com.sg
Subject: sql query
Date: 1999/04/05
Message-ID: <7ea3lk$dk7$1@nnrp1.dejanews.com>#1/1
X-Http-Proxy: NetCache@proxync2: Version 3.3.1, 1.0 x14.dejanews.com:80 (Squid/1.1.22) for client 160.96.179.5
Organization: Deja News - The Leader in Internet Discussion
X-Article-Creation-Date: Mon Apr 05 10:35:32 1999 GMT
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/2.0 (compatible; MSIE 3.02; Windows 95)


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