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
- 6541 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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain the term 'tables' related to relational database management system?
What happens in a conflict? How do you handle that?
What is meant by a Least Cost Plan?
How do you set the session mode parameters in bteq?
What are the joins in teradata and how many types of joins are there in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Highlight the differences between Primary Key and Primary Index.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Where is teradata rdbms used?
Differentiate database data and data warehouse data?
What are the different table types supported by teradata?
Explain teradata utilities?
What can be achieved by using the teradata rdbms?
What are the updated features of teradata?
