Re: Oracle 7.2 on NT 4.0 SP3 Performance Problem

Hi,

if you CBO then you should analyze your table to get actual statistics. Using indexes on DOORNUM would also increase the performance. Nnd LBNL try

 SELECT COUNT(B.DOORNUM)
 FROM BASIC B, DOOR D
 WHERE B.DOORNUM=D.DOORNUM; Wen-tau Yih schrieb:
>
> 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

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de Received on Fri May 15 1998 - 07:45:21 CDT