How many types of index are present in teradata?






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

Post New Answer




More Teradata Interview Questions

what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,


Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,


what is identity columns in teradata

2 Answers   Wipro,


any one pls tell me what are the table names in banking project?

2 Answers  


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

0 Answers  






In Teradata, what is the significance of UPSERT command?

0 Answers  


I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  


What are the types of tables in Teradata

22 Answers   Cognizant, Infosys, Cap Gemini,


Explain the new features of teradata?

0 Answers  


List out teradata data types?

0 Answers  


How would you load a very large file in teradata in general?

0 Answers  


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  






Categories