Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Server Recommendation
Are the columns in the table that you are querying against indexed?
That'll make a huge difference in performance.
"Scallica" <scallica_at_hotmail.com> wrote in message
news:bmiy9.4530$h4.2572_at_news4.srv.hcvlny.cv.net...
> Hello,
>
> I am very new to Oracle. I recently setup an Oracle 8 server on a NT 4
> server. I have have a database with 25 tables, the largest table having
> 450,000 records. The system is 500 mhz with 256mb of RAM. Is this
sufficient
> or does the machine need more horsepower? I have a VB app that uses the
> database and it runs really slow. Any ideas?
> Thanks.
>
> -Scallica-
>
>
Received on Thu Nov 07 2002 - 14:40:20 CST