Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how do I hint(parallel) 2 or more tables in a select statement
I have a 5 table join, 2 are full table i hinted one and it went to parallel
to parallel, but when i try to hint the other it only takes first table
I tried
select /*+ parallel (table1, 4) parallell (table2, 4) */
name ..
and
select /*+ parallel (table1, 4) (table2, 4) */ name ...
and
select /*+ parallel (table1, 4) parallell (table2, 4) */
/*+ parallel (table1, 4) parallell (table2, 4) */ name ...
but only the first table gets parallel, how do i get both to be parralleled Received on Wed Jan 19 2000 - 19:19:02 CST
![]() |
![]() |