If you are going to query on the field number shouldn't you create an index on that column
? Otherwise Oracle has to search each row until it finds the match.
Venkat
>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!
Received on Mon May 25 1998 - 09:30:25 CDT
