Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance problem
Since you apparently don't have an index on number, you must be doing a full
table scan. Try creating an index on the number column.
Klaus Hümmeler wrote in message <35696D47.AA701111_at_delphinsys.de>...
>Hi,
>
>I'm testing the performance of an Oracle8 evaluating version. Therefor I
>created a table with nearly 20000 rows containing 180 MB of data (number
>and varchar2).
>I made an primary index of one Column (varchar2) wich contains the
>entry-number.
>
>Every question like e.g. "select * from MaschDat where number = 100"
>takes
>nearly 2 Minutes until I get the selected row(s).
>
>Is Oracle really so slow, or what is my mistake??? The System, where
>Oracle is running, is an NT-Server with 200 MHz Pentium an 64 MB Ram.
>
>Please give me a hint for solving this problem!
>
>Regards Klaus
>
>---
>Dipl.-Ing. Klaus Huemmeler
>Delphin Prozesstechnik
>51515 Kürten / Germany
>EMail: khuemmeler_at_delphinsys.de
>
>
Received on Mon May 25 1998 - 11:14:47 CDT