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

What are the various reporting tools in the market?

How a Referential integrity is handled in Teradata?

How do you design aggregate tables using teradata?

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

Diff b/w v2r5 and v2r6 ?

What is teradata? What are some primary characteristics of teradata?

What do you mean by parsing?

What are different table types used in teradata?

What is teradata and why it is used?

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

If a Node is busy what are the steps you can take to avoid ?

What is the syntax for case when statement?

For more Teradata Interview Questions Click Here