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

What is a node in teradata?

959

What do you mean by teradata sql assistant?

1019

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

960

What is bteq script in teradata?

1109

Comment whether bottleneck is an error or not.

1101

How do you see a ddl for an existing table?

979

How to eliminate product joins in a teradata sql query?

977

What is the syntax for case when statement?

1085

What do you mean by caching in teradata?

1014

What is a sparse index?

1040

What are some commonly used bteq scripts?

968

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1060

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4345

What is the command in bteq to check for session settings ?

1139

What are some primary characteristics of teradata?

964