Can we collect statistics on table level?
No Answer is Posted For this Question
Be the First to Post Answer
What are the various reporting tools in the market?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Why are oltp database designs not generally a good idea for a data warehouse?
What is basic teradata query language?
How to identify ppi columns?
List out some of the primary characteristics of teradata.
What is the purpose of indexes?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is bteq script in teradata?
How will you solve the problem that occurs during update?
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