Parallel query works just fine with ORDER BY. Why do you think that its not
parallelized when you add ORDER BY? Have you looked at the explain plan?
"agichen" <agiNOagSPAM_at_feib.com.tw.invalid> wrote in message
news:28bc935d.a8d81a5a_at_usw-ex0102-011.remarq.com...
> Hello,there,
> Today,I write a statement like
> select /*+parallel(emp,4,2) full(emp) */ id,name,phone
> from emp
> where id in (12345,123456,1234)
> and birthday between '1-jan-1973' and '31-dec-1965'
>
> It can parallel run,but when I add a order by cause it can't
> be parallel run,what's wrong ??
>
> Can parallel hint work with "order by" ??
>
> Any limitation about parallel query (even in parallel dml )??
>
> Rgds,
> Agi Chen
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Jan 13 2000 - 00:15:01 CST
