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

Define views in teradata with syntax.

1085

Explain the term 'primary key' related to relational database management system?

1039

What are the different design perspectives used in teradata?

984

What are the available primary index types?

1223

What are the uses of bynets in multi-node systems?

1036

Discuss the advantages of using partitioned primary index in a query?

956

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

1085

what is object level locking ? where do appear this type of locking ?

3503

Can we collect statistics on multiple columns?

1069

Write a program to show the parser component used in teradata?

983

Differentiate primary key and partition key?

986

What tools would you use for that?

1115

What is the use of fallback?

996

How do you create tables? Exact syntax, and create profiles, users in teradata?

1041

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

1750