0 - 2 of 2 tags for redistribution
Help with avoiding redistribution using a hash index

Hi,

 

By ps.suma@gmail.com, 01 Dec 2014 | Tagged: ordered analytic function hash index redistribution | 4 comments
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]

By m.tahoon, 03 Mar 2013 | Tagged: left outer join redistribution | 1 comment