Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> where to put PARALLEL DEGREE in comples SELECT statement
I'm not sure where to put the keywords PARALLEL DEGREE
Do I put "parallel degree" twice for each subquery like this:
select yyyymm, subcount, totcount, subcount/totcount*100 pct
from
(select substr(BUDAT, 1,6) yyyymm, count(*) subcount from BSID
group by substr(BUDAT, 1,6) parallel ( degree 8 ) ),
(select count(*) totcount from BSID parallel ( degree 8 ));
or do let Oracle figure it out and just put it once at the end of the statement like this:
select yyyymm, subcount, totcount, subcount/totcount*100 pct
from
(select substr(BUDAT, 1,6) yyyymm, count(*) subcount from BSID
group by substr(BUDAT, 1,6)),
(select count(*) totcount from BSID)
parallel ( degree 8 );
Thanks for any info. Received on Mon Feb 11 2002 - 17:11:35 CST