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