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...


what is the difference between primary index and secondary index?.

Answers were Sorted based on User's Feedback



what is the difference between primary index and secondary index?...

Answer / yuvaevergreen

Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.

Is This Answer Correct ?    7 Yes 0 No

what is the difference between primary index and secondary index?...

Answer / tdguy

PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Teradata Interview Questions

What's the syntax of sub string?

1 Answers  


List out teradata data types?

0 Answers  


What is teradata? What are some primary characteristics of teradata?

0 Answers  


what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,


What is meant by a dispatcher?

0 Answers  


What are different table types used in teradata?

0 Answers  


On which column will you take primary index???

4 Answers  


Describe primary index in teradata?

0 Answers  


Explain amp in teradata?

0 Answers  


Can any one plz provide the teradata interview questions?

10 Answers  


What is a level of granularity of a fact table?

0 Answers  


"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  


Categories