Interested to Buy Any Domain ? << Click Here >> for more details...
What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 34472 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / adi
explain gives the execution strategy means what are the
different steps that the query will go through.
HIGH CONFIDENCE:Statistics are collected.
LOW CONFIDENCE:Statistics are not collected. But the where
condition is having the condition on indexed column. Then
estimations can be based on sampling.
NO CONFIDENCE:Statistics are not collected and the
condition is on non indexec column.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
why use references rather than pointers in the public api, particularly for arguments which are modified?
Why does varchar occupy 2 extra bytes?
What is real time and near real time data warehousing?
What are the advantages of teradata?
What are the primary characteristics of the Teradata.
Define views in teradata with syntax.
Can we collect statistics on table level?
What are the uses of client software involved in teradata?
What do you mean by tpt in teradata?
How will you solve the problem that occurs during update?
How would you load a very large file in teradata in general?
Explain teradata utilities. What is multiload, fast load, tpump?
Highlight the advantages of PPI(Partition Primary Index).
What is meant by Teradata Gateway?
What are the available primary index types?
