0 - 2 of 2 tags for NUPI vs 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??

Hi Experts,
Request you to spare the time to shed some light on below.
1.   "You might pick a NUPI over an UPI because the NUPI column may be more effective for query access and joins"