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 are the design features involved in teradata?

1008

What is the difference between fastload and multiload?

1321

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1684

What is meant by a Channel Driver?

1175

What is meant by a Highest Cost Plan?

1012

What is the multi-insert?

991

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2159

What is a three-tier data warehouse?

1071

What is a node in teradata?

959

What is bteq utility in teradata?

937

What tools would you use for that?

1061

What are the different table types supported by teradata?

914

Explain teradata vs. Redshift?

972

Why are oltp database designs not generally a good idea for a data warehouse?

1019

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

1193