How many types of index are present in teradata?

Question Posted / khem chand

How many types of index are present in teradata?..

Answer / 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

More Teradata Interview Questions

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

what is identity column in TD?

where we can use the delimiter in mload? pls let me know

How to load specific no.of records using bteq, or fastload,or multiload

What are the functions of a Parser?

What are the main components of teradata system?

in teradata level primary in table level allows duplicates why?

What is the purpose of using case expression in teradata?

What are the steps involved after the disk manager passes the request?

what do you mean by INMOD Routines and OUTMODE Routines ?

What is a pseudo key? What is its use???

What is the syntax for case when statement?

For more Teradata Interview Questions Click Here