1 )Primary index a)UPI b)NUPI 2) Secondary index a)USI b)NUSI 3)Parti

How many types of index are present in teradata?

Question Posted / krishna

Answer Posted / krishna

1 )Primary index
a)UPI
b)NUPI
2) Secondary index
a)USI
b)NUSI
3)Partition primary index
a)Range Partition
b)Case partition
4) Hash index
5)Jion index

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you fastexport a field, which is primary key by putting equality on that key?

701

Explain the meaning of Amp?

582

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1689

What is the difference between fastload and multiload?

783

In Teradata, how do we Generate Sequence?

597

What are the multiload utility limitations?

586

What are the functions performed by bynet?

599

In BTEQ, how are the session-mode parameters being set?

635

What are the primary characteristics of the Teradata.

579

What are different table types used in teradata?

577

Describe the set operators in teradata.

574

what is sysdba and sysdbc ? which has high priority ?

3357

List out teradata data types?

553

What do you mean by teradata intellicloud?

587

What are the steps involved in the process flow of the sql statement through channel attached system?

653