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
Answers were Sorted based on User's Feedback
Answer / 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 |
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Differentiate database data and data warehouse data?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
Difference between Qualify and group
Explain the term 'row' related to relational database management system?
How to cast date "2015-03-03-012204-000000" to timestamp
What is smp and mpp platforms?
How is MLOAD Client System restarted after execution?
How to eliminate product joins in a teradata sql query?
Mention a few of the ETL tools that come under Teradata.
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
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?