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 are the advantages of teradata?

0 Answers  


What are the different table types that are supported by teradata?

0 Answers  


if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,


What are the main components of teradata system?

0 Answers  


What are the uses of client software involved in teradata?

0 Answers  


What is multi insert?

0 Answers  


What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,


how do you manage the production space. what are the proactive methods you can take ?

0 Answers  


I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,


What is the command in bteq to check for session settings ?

0 Answers  


What are the 5 phases in a multiload utility?

0 Answers  


Categories