Can any one please provide me practical example of How to do the performance tuning in Query??
5 11638What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
5 34249Hello 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 15206Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
IBM,
2 9444How 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 13254In 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 16543Can 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 21292
Why are oltp database designs not generally a good idea for a data warehouse?
What is the command in bteq to check for session settings ?
what are the uses of fact table and dimension table in banking project?
What is partitioned primary index (ppi)?
What are the joins in teradata?
Explain the types of join supports by teradata?
What are the components provided on node?
How to view every column and the columns contained in indexes in teradata?
Describe primary index in teradata?
What are the available primary index types?
How you will check the version of teradata?
What is meant by a dispatcher?
What interface is used to connect to windows based applications?
What is the purpose of indexes?
What are the various reporting tools in the market?