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
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 |
What is a node in teradata?
How can we load single row of data into teradata database. please give me the process.
The transaction exceeded the maximum number of rowhash locks allowed
What are the functions performed by bynet?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
which option is used to restart the fast load script?
How to Extract data from multiple legacy systems?
What are two examples of an OLTP environment?
any one pls tell me what are the table names in banking project?
if collect stats but it show low confidence why?
What is oltp?
What are the things to be considered while creating secondary index?