What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
Answer Posted / yuvaevergreen
1.Explain helps us to know about the stats needed.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is a sparse index?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is basic teradata query language?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the multiload utility limitations?
What are the different methods ot loading a dimension table? A fact table etc?
What is dimensional modeling?
Highlight the need for Performance Tuning.
What are the design features involved in teradata?
What are tpump utility limitations?
What is real time and near real time data warehousing?
Why do you get spool space errors? How do trouble-shoot them?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.