Oracle 7.2 on NT 4.0 SP3 Performance Problem

From: Wen-tau Yih <wtyih_at_robot.csie.ntu.edu.tw>
Date: Fri, 15 May 1998 09:40:33 +0800
Message-ID: <355B9D11.76455EB0@robot.csie.ntu.edu.tw>

Hi all,

I wonder any of you have the same experience.

I recently installed Oracle 7.2 on NT 4.0 with SP3
(AMD K6-200, 96Mega RAM). When I ran the following
query, I found it cost me more than 1 minutes!

SELECT COUNT(*)
FROM BASIC B, DOOR D
WHERE B.DOORNUM=D.DOORNUM; Both TABLE BASIC and TABLE DOOR have about 14,000 rows. I've tried the same query in Access on my desktop
(Pentium-200, 32 Mega RAM), it cost no more than ten seconds!

I believe that Oracle should have better performance. Is there any parameter I forgot to tune?

Thx.

Scott Yih Received on Thu May 14 1998 - 20:40:33 CDT