All Forums Database
m.tahoon 43 posts Joined 09/11
03 Mar 2013
Redistribution with LOJ despite same PI

when i Join two tables having the same PI using Left outer Join on the PI (same column on both tables) ; Redistribution occur.
However Inner join do not cause redistribution
[by way of a RowHash match scan with]

dnoeth 4628 posts Joined 11/04
04 Mar 2013

You should post SQL/Explains because this is an unusual behavior.

DIeter

Dieter

You must sign in to leave a comment.