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
- 6339 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
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the parallel data extension in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What happens when a node suffers a downfall?
What are the uses of bynets in multi-node systems?
In Teradata, how do we Generate Sequence?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is TPD?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
List out some of the primary characteristics of teradata.
What are the different functions included in the server software?
What is inner join and outer join?
Highlight the need for Performance Tuning.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the multiload utility limitations?
