What is the use of having index on table?


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

Post New Answer

More Teradata Interview Questions

What are the primary characteristics of the Teradata.

0 Answers  


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  


wt r before journal& after journel.....in teradata

4 Answers  


how can we analyze the locks ?

0 Answers   HP,


What are the available join types in teradata?

0 Answers  






i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


How do you eliminate duplicates?

3 Answers  


What do you mean by caching in teradata?

0 Answers  


I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,


If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

1 Answers   Teradata,


What are the main components of teradata system?

0 Answers  


what is DYNAMIC SQL in TD?

1 Answers   IBM,


Categories