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

Do indexes matter on db in memory

From: <new_user_at_email.msn.com>
Date: 2000/04/16
Message-ID: <Och5aw$p$GA.225@cpmsnbbsa03>#1/1 






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 Sun Apr 16 2000 - 00:00:00 CDT












Original text of this message













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