All Forums Database
barani_sachin 141 posts Joined 01/12
15 Jul 2013
For joins NUPI can be a better choice than a UPI

Hi All,
    I have read that "For join performance, a NUPI can be a better choice than a UPI."
Someone please explain why is that? If it is a PI join then it is an same AMP operation how does NUPI will serve better than a UPI??

barani_sachin 141 posts Joined 01/12
05 Aug 2013

Any one please??

ulrich 816 posts Joined 09/09
05 Aug 2013

you don't give any context for "For join performance, a NUPI can be a better choice than a UPI." so it would require again the crystal ball to come up with a reply...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Shelley 28 posts Joined 09/10
06 Aug 2013

As ulrich says, you need the context because it really depends on your data and what you need to join on.
For example if your joins are most often on columns that will have duplicates  then a NUPI using those column(s) may be a better choice than creating a unique PI using a column(s)  that are not always  used in the join.
As long as there is reasonable distribution with the nupi columns( not too many duplicates) then it will work well.
---Shelley

You must sign in to leave a comment.