Slow query
From: Sashi <smalladi_at_gmail.com>
Date: Thu, 7 Feb 2008 06:32:02 -0800 (PST)
Message-ID: <f9df77a7-e4dc-463f-a8d7-6f1fcf9ec5c9@e25g2000prg.googlegroups.com>
Date: Thu, 7 Feb 2008 06:32:02 -0800 (PST)
Message-ID: <f9df77a7-e4dc-463f-a8d7-6f1fcf9ec5c9@e25g2000prg.googlegroups.com>
Hi all, I'm running a simple select by joining two tables.
I get an output of about 1.3 million rows:
SQL> SELECT count(*) from QIPADMIN.OBJ_NAME_PROF O, QIPADMIN.OBJ_PROF N WHERE N.OBJ_ID=O.OBJ_ID; COUNT(*)
1322139
When I run the select query as follows:
SELECT UPPER(OBJ_NAME), N.OBJ_IP_ADDR1 , N.OBJ_IP_ADDR2 ,N.OBJ_IP_ADDR, N.OBJ_IP_ADDR4 from QIPADMIN.OBJ_NAME_PROF O, QIPADMIN.OBJ_PROF N WHERE N.OBJ_ID=O.OBJ_ID it takes almost three hours to run. The server is only hosting the data server and the CPU usage is low.
Any pointers in helping me resolve this issue are appreciated.
Thanks in advance,
Sashi
Received on Thu Feb 07 2008 - 08:32:02 CST