HIGH CONFIDENCE:Statistics are collected up to date. LOW CONFIDENCE:Statis

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

Question Posted / farooq

Answer Posted / farooq

HIGH CONFIDENCE:Statistics are collected up to date.
LOW CONFIDENCE:Statistics are not up todate.
NO CONFIDENCE:Statistics are not collected.

Is This Answer Correct ?

16 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why teradata is used?

938

Highlight the differences between Primary Key and Primary Index.

1016

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

927

What are the frequently used data types in teradata?

1001

What is the meaning of Caching in Teradata?

1079

Explain teradata architecture in detail with a diagram.

1046

Explain the new features of teradata?

990

What do you mean by teradata sql assistant?

995

What is meant by a Highest Cost Plan?

988

How do you determine the number of sessions?

1007

What are some commonly used bteq scripts?

942

Different phases of multiload?

935

Highlight the points of differences between the database and user in Teradata.

1037

Explain the term 'foreign key' related to relational database management system?

956

If a Node is busy what are the steps you can take to avoid ?

2346