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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by teradata sql assistant?

1042


What do you mean by teradata intellicloud?

1024


What is the meaning of Caching in Teradata?

1120


What are the primary characteristics of the Teradata.

1128


What is logical data model?

1189


Can we collect statistics on table level?

1014


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

979


How many types of joins are there in teradata?

958


How does hashing happens in teradata?

1073


Explain the types of join supports by teradata?

976


What is the use of having index on table?

987


What are the scenarios in which full table scans occurs?

994


What are the frequently used data types in teradata?

1058


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1138


What is meant by a Parsing Engine?

1174