Parallel Query Question ~~

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!