Re: Do indexes matter on db in memory

That seems like quite a simplistic viewpoint. I'd be happier if he was saying "I've looked at the high impact SQL and none of it can be improved by adding indexes". I'd tend to monitor v$sqlarea looking for high disk_reads and buffer_gets. Those are the statements that need help and may benefit from some attention, though not necessarily more indexes.
There's a good script to do this on Jonathan Lewis' site (http://www.jlcomp.demon.co.uk/).

Regards

Mike Hately

( <new_user_at_email.msn.com> wrote in message news:Och5aw$p$GA.225_at_cpmsnbbsa03...
> 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.
>
>
Received on Mon Apr 17 2000 - 00:00:00 CDT