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
- 6456 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
Which is faster fastload or multiload?
List out some of the primary characteristics of teradata.
How do you set the session mode parameters in bteq?
Why managing the data is important?
Can we collect statistics on table level?
What is node? How many nodes and amps used in your previous project?
What is called partitioned primary index (ppi)?
Write a program to show the parser component used in teradata?
Explain fastload in teradata?
What are the uses of client software involved in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are teradata utilities?
What are the various indexes in teradata? How to use them?
Describe primary index in teradata. And what are the available primary index types?
What is the purpose of joins in teradata?
