What are the various indexes in teradata? Why are they preferred?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  


How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers  


How to copy 1 million records from one DB to another, Which is effective interms of performance?

4 Answers  


What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  


What does sleep function does in fast load?

0 Answers  






What is the particular designated level at which a LOCK is liable to be applied in Teradata?

0 Answers  


What is the use of having index's on table?

1 Answers  


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

0 Answers  


Highlight the limitations of TPUMP Utility.

0 Answers  


Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,


why varchar takes 2 extra bytes?

4 Answers   IBM,


What is node? How many nodes and amps used in your previous project?

0 Answers  


Categories