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

What are the different functions included in the server software?

999

In general, how do you optimze any sql in teradata?

1004

What are the 5 phases in a multiload utility?

1005

List the logical and conditional operators that are used with teradata along with their meanings?

965

What is upsert statement in teradata?

1077

What is the multi-insert?

995

What is the use of teradata system software?

1007

What type of indexing mechanism do we need to use for a typical data warehouse?

1116

Explain and compare pros and cons of snow flake schemas?

1007

Why does varchar occupy 2 extra bytes?

1140

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

1195

What are the functions performed by bynet?

1014

What is primary index and secondary index?

995

What are the functions of a teradata dba?

1044

Explain the term 'row' related to relational database management system?

909