1.Explain helps us to know about the stats needed.

What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Is This Answer Correct ?

3 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Difference between stored procedure and macro?

1173

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1241

What are the steps involved after the disk manager passes the request?

1121

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837

What is the opening step in basic teradata query script?

1038

What are the design features involved in teradata?

1058

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

What is the difference between global temporary tables and volatile temporary tables?

1182

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3625

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

What do you mean by fastexport in teradata?

1003

What is a node in teradata?

1000

What is the purpose of joins in teradata?

1190

How will you solve the problem that occurs during update?

1055

What are the various indexes in teradata? How to use them?

1018