Question: what is nusi in teradata?
Answer: A Non-Unique Secondary Index (NUSI) is usually specified to prevent full-table scans, in which every row of a table is read. When A NUSI is created Teradata will immediately build a secondary index subtable on each AMP.