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

What is TPD?

1368

Explain the new features of teradata?

1032

How many sessions of MAX is PE capable of handling at a particular time?

1079

What do high confidence, low confidence and no confidence mean in explain plan?

1043

Highlight the need for Performance Tuning.

1103

Differentiate primary key and partition key?

979

What are the primary characteristics of the Teradata.

1144

What are the main components of teradata system?

1125

What are the string manipulation operators and functions associated with teradata?

1083

What is the purpose of joins in teradata?

1171

List out teradata data types?

1002

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1072

What are the multiload utility limitations?

1045

What are the different methods ot loading a dimension table? A fact table etc?

1033

What are the things to be considered while creating secondary index?

1098