如果是12核的处理器,是这样写的吗?:select /*+parallel(X,10)(A,10)(B,10)(C,10)(D,10)(E,10)(F,10)*/ X.sfz,B.id,D.hm,E.bh,F.lx from X
left join A
on X.sfz = A.sfz
left join B
on X.sfz = B.sfz and B.id>=1
left join C
on C.sfz = X.sfz
left join D
on D.sfz = X.sfz and D.hm=B.id
left join E
on A.mc = E.bh
left join F
on F.sn=C.sn and F.lx=B.id
left join A
on X.sfz = A.sfz
left join B
on X.sfz = B.sfz and B.id>=1
left join C
on C.sfz = X.sfz
left join D
on D.sfz = X.sfz and D.hm=B.id
left join E
on A.mc = E.bh
left join F
on F.sn=C.sn and F.lx=B.id
left join A
on X.sfz = A.sfz
left join B
on X.sfz = B.sfz and B.id>=1
left join C
on C.sfz = X.sfz
left join D
on D.sfz = X.sfz and D.hm=B.id
left join E
on A.mc = E.bh
left join F
on F.sn=C.sn and F.lx=B.id
/*+ leading(Y) parallel(X, 2) parallel(Y, 2) use_hash(X Y) */