Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PQ_DISTRIBUTE Usage in NON Parallel Queries

PQ_DISTRIBUTE Usage in NON Parallel Queries

From: Larry Elkins <elkinsl_at_flash.net>
Date: Fri, 4 Feb 2005 19:41:41 -0600
Message-ID: <MPBBKDBLJAGDLMINJNKBOEAOECAB.elkinsl@flash.net>


Listers,

In what way does the PQ_DISTRIBUTE "hint" apply to non parallel queries? I ran into a need to use a stored outline a while back. And the query does not use parallelism. When capturing the desired plan in the OL$HINTS table for the outline there is a PQ_DISTRIBUTE hint. The docs categorize it as a parallel related hint, and I've had to use it a couple of times in the past related to parallel queries for huge batch jobs (and yes, I tried tweaking stats first ;-)).

This actually came up a couple of months ago, and I no longer have access to the system or else I would dig into it a bit more, and even provide the SQL, it's plan, and the data from OL$HINTS to the list. But no can do without access to it. I just find it odd that the docs, and whatever else Oracle puts out on Metalink, etc, that it is always referred to as being a parallel related hint. Yet it appears in OL$HINTS for a SQL statement not using parallelism.

Oh yeah, 9.2.0.5 EE. And I'm going to see if I can duplicate on 8i and 9i here at home, but thought I would throw the question out to the list as well.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 04 2005 - 20:37:29 CST

Original text of this message

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