Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how do I hint(parallel) 2 or more tables in a select statement

how do I hint(parallel) 2 or more tables in a select statement

From: dad <dsadasd_at_hotmail.com>
Date: 19 Jan 2000 19:19:02 -0600
Message-ID: <7oth4.10659$Ye.101982@newscene.newscene.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US