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
Answer Posted / rkraju
when we collect stats the demographic information stored on
table header.so the optimizer picks the stats information
from the table header for generating plan for a given query.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give the sizes of SMALLINT, BYTEINT and INTEGER.
if collect stats but it show low confidence why?
What is teradata and why it is used?
During the Display time, how is the sequence generated by Teradata?
What is meant by a Parsing Engine?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
how can we analyze the locks ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What happens when a node suffers a downfall?
How is MLOAD Client System restarted after execution?
How many codd's rules are satisfied by teradata database?
What are the components used in smp and massively parallel processing (mpp) machines?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is a dimension table?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?