meaning on PARALLEL_TO_SERIAL

From: Steve <smontgomerie_at_hotmail.com>
Date: 27 Aug 2002 07:14:16 -0700
Message-ID: <156709aa.0208270614.11f8b970_at_posting.google.com>

meaning on PARALLEL_TO_SERIAL

Looking through some metalink forum entries I've seen people mention that PARALLEL_TO_SERIAL is a bad thing to be avoided.

If my table is set to degree of 8 and stats are genereated can I turn pqo off to see if I get a better plan?

Here is what I've tried but from the explain I can still see pqo and PARALLEL_TO_SERIAL.

tks

steve
SELECT /*+ NOPARALLEL(AFE) */ DISTINCT afe.BUSINESS_UNIT, AFE.ACTIVITY_ID, AFE.CURRENCY_CD, AFE.ANALYSIS_TYPE, AFE.PRODUCT, SUBSTR(AFE.PRODUCT,5,2), AFE.BUSINESS_UNIT_GL, TO_CHAR(AFE.ACCOUNTING_DT, 'YYYYMMDD'), TO_CHAR(AFE.ACCOUNTING_DT, 'MM'), TO_CHAR(AFE.ACCOUNTING_DT, 'YYYY'), AFE.RESOURCE_AMOUNT, AFE.FOREIGN_AMOUNT FROM
PS_PROJ_RESOURCE AFE
WHERE AFE.BUSINESS_UNIT = 'BR'

AND AFE.ACTIVITY_ID <> 'LOE' 
AND AFE.ACCOUNT BETWEEN '20000' and '25399' 
AND AFE.ANALYSIS_TYPE IN ('ACT', 'ACR', 'TCR', 'TAR', 'ACC', 'TAA', 'TCA') 

AND TO_CHAR(AFE.ACCOUNTING_DT, 'YYYY') = TO_CHAR(LAST_DAY(sysdate), 'YYYY') Received on Tue Aug 27 2002 - 16:14:16 CEST