Redistribution with LOJ despite same PI

Database
Enthusiast

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]
1 REPLY
Junior Contributor

Re: Redistribution with LOJ despite same PI

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

DIeter