Re: the need for speed

Lots of factors can cause the performance that you are seeing. Even a Ferrari can perform poorly at times. Throw some bicycle tires on it and pour sugar in the gas tank. Now even a little Honda motor scooter can beat it. But take care of the Ferrari and the motor scooter will never even come close.

For starters, searching for half of a 100,000 row table is quickest by doing a full table scan. Are you using an index in your search? If so, that can slow it down. You'll have to use EXPLAIN PLAN to determine if you are using an index.

After that, look at things like you BUFFER CACHE. How big (or small) is it? How about other tuning aspects? Refer to the Oracle Tuning Guide.

HTH,
Brian

tshb_at_techprt.co.uk wrote:
>
> Hi,
> I'm very new to Oracle and databases generally, so this might be a
> stupid question. I'm searching for fifty thousand values (stored as the
> primary key in a table) in a table of one hundred thousand (again, the
> primary key). The SQL is SELECT n.ID, c.ID FROM temp n,main c WHERE c.ID
> = n.ID ORDER BY n.ID.
> No great shakes, I'm just wondering why it takes about 4 seconds to do
> it (from SQL Plus). Shouldn't it be quicker? Admittedly its a lot
> quicker than Access but how come search engines can find fifty trillion
> pages in 0.4 nano-seconds?
> I'm using Oracle 8 Personal Edition, would using another version speed
> it up?
> thanks,
>
> Tim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================