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
- 6340 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
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain the teradata primary index mechanics in detail with a diagram.
In Teradata, what is the significance of UPSERT command?
What is the difference between global temporary tables and volatile temporary tables?
Explain how spool space is used.
how do you manage the production space. what are the proactive methods you can take ?
How many tables can you join in v2r5?
How does hashing happens in teradata?
Explain the term 'row' related to relational database management system?
What do you mean by tpt in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain and compare pros and cons of snow flake schemas?
What is oltp?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
