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: How can I further reduce physical read for this query short of throwing memory at it?

Re: How can I further reduce physical read for this query short of throwing memory at it?

From: Jining Han <jining.han_at_gmail.com>
Date: 13 Feb 2006 20:29:03 -0800
Message-ID: <1139891343.179435.154500@g47g2000cwa.googlegroups.com> 





I have not done anything in terms of pinning any objects in either
pool, not sure if that helps.  By the way,   I have tried using an
index on the ORG table,  but as you may suspect,  the savings is
basically non-significant.



Thanks


JH
Received on Mon Feb 13 2006 - 22:29:03 CST












Original text of this message













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