All Forums Database
dsnaveen 6 posts Joined 07/10
09 Aug 2013

Hi Guys,
Can please someone let  me know in which scenario we need to use USI and NUSI.
1 or 2 example would be great.
Thank you,

dnoeth 4628 posts Joined 11/04
09 Aug 2013

Hi Naveen,
SIs in Teradata are rarely used for Joins (different to other DBMSes), so they're usually implemented to get a faster (index-based) access (this is the same in any other DBMS). As you can't force the optimizer to use a SI (no hints), you have to Collect Stats and then check Explain if the SI is used.
USI might also be used for implementing the logical PK (again the same in any DBMS, but hardly done in a DWH).


You must sign in to leave a comment.