Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.2 on NT 4.0 SP3 Performance Problem
Not sure if you created any indexes?
Wen-tau Yih wrote:
> 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 Fri May 15 1998 - 07:58:47 CDT