Multiset and UPI in GTT.


Multiset and UPI in GTT.

Hi all,

While doing performance optimization, I have come across a scenario where a GTT is declared as Multiset and UPI is also declared on the GTT. Will there be any performance hit because of this. Can anyone explain how Teradata internally works in this case?

What I am planning is to remove UPI and make it only PI, since it is a Multi set table.

Thanks in advance..

Re: Multiset and UPI in GTT.

Follow the discussion here and pay particular attention to Todd Walter's comments: