Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance problem
Try: select * from MaschDat where number = '100';
If you don't use quotes oracle will convert this column to numeric values, thus causing a table scan.
In article <6kbveg$e5k_at_sjx-ixn9.ix.netcom.com> "Venkat" <vreddy_at_no_spamix.netcom.com> writes:
>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 Tue May 26 1998 - 23:24:45 CDT