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: Do indexes matter on db in memory

Re: Do indexes matter on db in memory

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/04/17
Message-ID: <38FB0807.ED5@yahoo.com>#1/1

( wrote:
>
> We have a heavily used oracle database that is 100MB in size, the amount of
> memory
> on the server is 1G. The dba says that since the major queries get run so
> often that the data is all in memory and further indexes won't help the
> performance.
>
> Is the true? Can anyone tell me reasons why this might not be the optimal
> way to run a heavily used database.
>
> Thanks.

That is a simplification...

Eg

select *
from tableX, tableY

if both tables are 100M results could result in a 10,000M result set - which won't fit into 1G.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Mon Apr 17 2000 - 00:00:00 CDT

Original text of this message

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