Parallel Hint -
07-20-2006
, 01:38 PM
Hi,
Can someone tell me the difference between the following two usages of
paralle hint?
1. select /*+ PARALLEL*/ * from emp;
2. select /*+ PARALLEL(t,default)*/ * from emp t;
The degree of emp table is 1.
Both queries appear to generate differnt SQLs when it spawns threads.
Thanks
Jerry |