How many types of index are present in teradata?

How many types of index are present in teradata?..

Answer / krishna

1 )Primary index
2) Secondary index
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