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

What are the different design perspectives used in teradata?

0 Answers  

What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

How can you track login parameters of users in teradata?

0 Answers  

can we load 10 millions of records into target table by using tpump?

1 Answers   HP,

Why Multiload does not supports USI and supports NUSI?

4 Answers  

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

What are the different functions included in the server software?

0 Answers  

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  

How can bottlenecks be identified?

0 Answers  

What are the different methods ot loading a dimension table? A fact table etc?

0 Answers  

For more Teradata Interview Questions Click Here
Categories