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 is real time and near real time data warehousing?

1118

What are default access rights in teradata?

1126

What are the different functions included in the server software?

1034

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

Why does varchar occupy 2 extra bytes?

1198

What are the frequently used data types in teradata?

1085

What are the advantages of teradata?

1017

Discuss the advantages of using partitioned primary index in a query?

955

What do you mean by tpt in teradata?

1021

What do you mean by teradata sql assistant?

1065

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

1071

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

1043

What is bteq script in teradata?

1158

How is MLOAD Client System restarted after execution?

1157

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

1168