RE: parallel query and direct path read

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 1 Jul 2013 16:59:34 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901409F2C_at_exmbx06.thus.corp>


First step - check the execution path.

I don't think I've had any surprises with direct path not appearing when expected just because there's a join in place.

Regards
Jonathan Lewis



From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Ls Cheng [exriscer_at_gmail.com] Sent: 01 July 2013 12:51
To: Oracle Mailinglist
Subject: parallel query and direct path read

Hi
Does anyone know if direct path read cannot be used when the query is a join?

For example (dimension has parallel degree 8 so fact)

select *
from dimension d, fact f
where d.id = f.id;

Can direct path happen in this case? I am running 11.2.0.3 and I am pretty sure in 10gR2 this sort of query could use direct path reads.-- http://www.freelists.org/webpage/oracle-l Received on Mon Jul 01 2013 - 18:59:34 CEST

Original text of this message