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

How do you do backup and recovery in teradata?

0 Answers  


If table have access lock.In the same table write lock is posible or not?

1 Answers  


How to copy 1 million records from one DB to another, Which is effective interms of performance?

4 Answers  


Explain teradata vs. Redshift?

0 Answers  


Highlight the differences between Primary Key and Primary Index.

0 Answers  


How do you verify a complicated sql?

0 Answers  


What is the difference between union and union all in teradata?

0 Answers  


How many macros we can create inside a macro

1 Answers   Wipro,


whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,


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

0 Answers  


Can we collect statistics on table level?

0 Answers  


What is spool space?

0 Answers  


Categories