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

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

0 Answers  

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

How does indexing improve query performance?

4 Answers   Satyam,

Difference between inner join and outer join?

0 Answers  

What is logical data model?

0 Answers  

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

How do you verify a complicated sql?

0 Answers  

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

Difference between Teradata V2R5 and Teradata V12 versions?

2 Answers   IBM,

If the script is aborted. why it is aborted and how can you identify ?

1 Answers  

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

For more Teradata Interview Questions Click Here
Categories