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

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1314

What are the different functions included in the server software?

1081

What are the various indexes in teradata? How to use them?

1071

What are the scenarios in which full table scans occurs?

1051

What is teradata?

1235

any one answer me how they can analyzing the project using data ware housing?

2519

Which is faster fastload or multiload?

1176

What are the joins in teradata and how many types of joins are there in teradata?

1055

How can bottlenecks be identified?

1060

What is primary index and secondary index?

1066

Differentiate database data and data warehouse data?

1161

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

1189

What are the different functions performed in development phase?

1128

What are the newly developed features of Teradata?

1081

List the logical and conditional operators that are used with teradata along with their meanings?

1039