Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / gowthami8.b

Answers were Sorted based on User's Feedback



Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exl..

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

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exl..

Answer / 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

More Teradata Interview Questions

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

6 Answers   Bank Of America, Wipro,

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

How do you do backup and recovery in teradata?

0 Answers  

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

What is dimensional modeling?

0 Answers  

Can you load multiple data files for same target table using fastload?

1 Answers  

how to load or extract the error table data ?

3 Answers  

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers  

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

For more Teradata Interview Questions Click Here
Categories