Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frnds this question is asked at IBM
One query is there when we dont collect stastics on
it,exlapin will show us LOW CONFIDENCE,When we collect
stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL
ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012
THANKS IN ADVANCE
- 2 Answers
- 6453 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
statistics collection is a concept, where TD stores the
demographic data and stores. When generating the explain
plan, TD looks for the stats for the columns used in the
sql., particularly the columns used on both sides of the
join. TD prepares a estimate based on the data available.If
enough stats are not available, TD displays a low
confidence. Whereas, if stats are collected for columns
involved in sql, stats will be available for TD, which in
turn displays a high confidence, which means exact or close
approximate no of rows processed will be displayed.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'row' related to relational database management system?
What are normalization, first normal form, second normal form and third normal form?
Explain the parallel data extension in teradata?
What are the advantages of teradata?
What is bteq utility in teradata?
Syntax for case when statement?
What is the purpose of using case expression in teradata?
What are the available primary index types in teradata.
Steps to create a data model?
What are some primary characteristics of teradata?
What are the uses of bynets in multi-node systems?
How do you set the session mode parameters in bteq?
What are the joins in teradata and how many types of joins are there in teradata?
Mention a few of the ETL tools that come under Teradata.
Explain vproc in teradata?
