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
- 34046 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
What are the functions involved in shared information architecture?
Why do you get spool space errors? How do trouble-shoot them?
What do you mean by teradata intellicloud?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Highlight a few of the important components of Teradata?
What are the 5 phases in a multiload utility?
How do you do backup and recovery in teradata?
What is the difference between fastload and multiload? Which one is faster?
Highlight the limitations of TPUMP Utility.
What are the enhanced features in teradata v2r5 and v2r6?
What are the commands to make a new table, change a table and remove a table in teradata?
How to view every column and the columns contained in indexes in teradata?
If RDBMS is halted what will you do ?
Steps to create a data model?
