Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance problem

Re: performance problem

From: Donne You <dy_at_gomez.physics.lsa.umich.edu>
Date: Wed, 27 May 1998 04:24:45 GMT
Message-ID: <hAMa1.245$iY6.865025@news.itd.umich.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US