Can any one please provide me practical example of How to do the performance tuning in Query??
5 11656What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
5 34277Hello 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 15233Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
IBM,
2 9469How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
3 13286In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
3 16557Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
IBM,
6 21330
Explain vproc in teradata?
How is MLOAD Client System restarted after execution?
Steps to create a data model?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the term 'primary key' related to relational database management system?
What is meant by a Parsing Engine?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the uses of bynets in multi-node systems?
What do you mean by teradata sql assistant?
What is difference between user and database in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
if collect stats but it show low confidence why?
What is real time and near real time data warehousing?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?