performance problem

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 - 08:08:23 CDT