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
- 33999 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
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the enhanced features in teradata v2r5 and v2r6?
Explain the term 'row' related to relational database management system?
What is called partitioned primary index (ppi)?
What do you mean by teradata sql assistant?
What is the use of virtual processor connectivity in teradata?
If RDBMS is halted what will you do ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are default access rights in teradata? What explicit right can be given to a user?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the various etl tools in the market?
Explain parsing engine in teradata?
How to find duplicates in a table?
