Can any one please provide me practical example of How to do the performance tuning in Query??
5 9957What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
5 31938Hello 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 13137Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
IBM,
2 8080How 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 11734In 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 15154Can 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 18965
What is spool space?
How to find duplicates in a table?
What are the frequently used data types in teradata?
Highlight the differences between Primary Key and Primary Index.
Explain some differences between mpp and smp?
What is bteq utility in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are teradata utilities?
Difference between inner join and outer join?
What are the things to be considered while creating secondary index?
What are the uses of client software involved in teradata?
What are the available primary index types?
What is meant by a Virtual Disk?
if collect stats but it show low confidence why?
Explain amp in teradata?