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
- 6465 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
When tpump is used instead of multiload?
What are the commands to make a new table, change a table and remove a table in teradata?
why should we go Teradata over Oracle,what is the main differences?
What is the purpose of joins in teradata and what are the available join types?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
which utitility can use for loading the data from non-teradata to teradata ?
What is the difference between SI and JI?
What is the function of parser component in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are some primary characteristics of teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the main components of teradata system?
Teradata 
