Re: index with very high LIO

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: jeremy.schneider@xxxxxxxxxxxxxx
  • Date: Thu, 17 Nov 2011 11:24:49 -0800

Am I reading this right?  7 million rows joined using NESTED LOOPS
join?  Wouldn't a parallel hash join be better/faster?

On Thu, Nov 17, 2011 at 3:34 AM, Jeremy Schneider
<jeremy.schneider@xxxxxxxxxxxxxx> wrote:
> PS... 8k block size; segment of index in question is 100G.  Query is
> pulling 7 million rows from a join of two billion row tables...

-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


Other related posts: