Parallel Hint

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 Received on Thu Jul 20 2006 - 13:38:59 CDT