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 different table types supported by teradata?

List the logical and conditional operators that are used with teradata along with their meanings?

Difference between inner join and outer join?

How to relege locks in fastload and multiload? example?

what is the difference between filter and router transmissions

what are the file sizes in your project?

What is the command in bteq to check for session settings ?

Which is faster fastload or multiload?

How can we load single row of data into teradata database. please give me the process.

What is the function of parser component in teradata?

What are the available primary index types?

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

For more Teradata Interview Questions Click Here