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
- 6416 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain the term 'database' related to relational database management system?
What is the use of stored procedures in teradata?
Explain Teradata performance tuning and optimization?
What are normalization, first normal form, second normal form and third normal form?
What are the design features involved in teradata?
Highlight the limitations of TPUMP Utility.
Difference between inner join and outer join?
What are the available primary index types in teradata.
What are the various indexes in teradata? Why are they preferred?
How many codd's rules are satisfied by teradata database?
What is a three-tier data warehouse?
What is the command in bteq to check for session settings ?
What is the maximum number of dml can be coded in a multiload script?
Why managing the data is important?
Explain the term 'tables' related to relational database management system?
