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 is identity columns in TD?

What are the different table types supported by teradata?

What is the opening step in basic teradata query script?

What are the different methods ot loading a dimension table? A fact table etc?

Is multi insert ansi standard?

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

What is the maximum number of dml can be coded in a multiload script?

Did you write stored procedures in teradata?

Why do you get spool space errors? How do trouble-shoot them?

How to run the Teradata jobs in unix environment ???

During the Display time, how is the sequence generated by Teradata?

For more Teradata Interview Questions Click Here