Re: index with very high LIO

From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 17 Nov 2011 11:24:49 -0800
Message-ID: <CAGXkmitd5shDw0zZjh121xSffQNYJuRKsvqc4AwjuXMAdaqjng_at_mail.gmail.com>

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_at_ardentperf.com> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2011 - 13:24:49 CST