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: <xhoster_at_gmail.com>
Date: 13 Feb 2006 20:00:46 GMT
Message-ID: <20060213150131.329$mA@newsreader.com> 





Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:


> >

> > Tables and # of records: ORG:   72393,   SALES:  45787748

> > # of records meeting SELECT criteria:  296771

> >



...



> Why is the ORG table parallel? 70k rows might be better

> off non-parallel.




Doesn't ORG have to be accessed in parallel if it is going to be used
to drive a parallel NL on SALES?



Xho


-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB


Received on Mon Feb 13 2006 - 14:00:46 CST












Original text of this message













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