All Forums General
suhail 1 post Joined 02/13
02 Feb 2013
Regarding the Secondary Index

I am planning to do TeraData Basic Certifications. I need correct of some questions with reason on secondary Index. Hope I will get help from this forum.
What is a reason to use a USI over a NUSI when creating a table?
a.They ensure data uniqueness.
b.They are a oneAMP operation.
c.They are needed for journaling.
d.They are supported by the batch load utilities.
 Why would a USI be chosen instead of a NUSI?
a.It is a single AMP operation.
b.It does not add overhead to the table.
c.It ensures that unique data is inserted into the table.
d.It accesses all AMPs but is more efficient than a Full Table Scan (FTS).

Qaisar Kiani 337 posts Joined 11/05
06 Feb 2013


You must sign in to leave a comment.