in the following link
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533/hintsref.htm#5879
it said the first parameter of this hint is:
table_name is the name or alias of a table to be used as the inner table of a join.
I guess inner table is the second table to be joined in the execution plan.
My question is how to use the hint to get the plan in line 50 to do broadcast. For the line of 55, use can use hint PQ_DISTRIBUTE(Z, BROADCAST, none), since Z if the second table of the join between Y & Z (if the inner table is the second table as I think). But for the line 50, the join is between X & result of join between(Y,Z), so the second table should be the result of join of Y & Z. But how can I put the result set of y join z as the first parameter of PQ_DISTRIBUTE. Looks like I need to use PQ_DISTRIBUTE(result_of_join_Y&Z, BROADCAST, none)
| 46 | PX SEND HASH | :TQ10008 | 3067 | 263K| 15808 (34)| 00:01:09 | Q1,08 | P->P | HASH |
|* 47 | HASH JOIN | | 3067 | 263K| 15808 (34)| 00:01:09 | Q1,08 | PCWP | |
| 48 | BUFFER SORT | | | | | | Q1,08 | PCWC | |
| 49 | PX RECEIVE | | 167 | 6513 | 165 (35)| 00:00:01 | Q1,08 | PCWP | |
| 50 | PX SEND BROADCAST | :TQ10000 | 167 | 6513 | 165 (35)| 00:00:01 | | S->P | BROADCAST |
|* 51 | TABLE ACCESS FULL | X | 167 | 6513 | 165 (35)| 00:00:01 | | | |
|* 52 | HASH JOIN | | 469K| 21M| 15636 (34)| 00:01:09 | Q1,08 | PCWP | |
| 53 | BUFFER SORT | | | | | | Q1,08 | PCWC | |
| 54 | PX RECEIVE | | 469K| 15M| 15580 (34)| 00:01:08 | Q1,08 | PCWP | |
| 55 | PX SEND BROADCAST | :TQ10001 | 469K| 15M| 15580 (34)| 00:01:08 | | S->P | BROADCAST |
|* 56 | TABLE ACCESS FULL| Y | 469K| 15M| 15580 (34)| 00:01:08 | | | |
| 57 | PX BLOCK ITERATOR | | 216K| 2962K| 39 (36)| 00:00:01 | Q1,08 | PCWC | |
| 58 | TABLE ACCESS FULL | Z | 216K| 2962K| 39 (36)| 00:00:01 | Q1,08 | PCWP |