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

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

996


Give the sizes of SMALLINT, BYTEINT and INTEGER.

1172


What do you mean by teradata intelliflex?

1113


Which is more efficient group by or distinct to find duplicates?

1093


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2869


In BTEQ, how are the session-mode parameters being set?

1146


How to select first n records in teradata?

1111


What are the functions involved in shared information architecture?

1075


What do you mean by teradata sql assistant?

1068


what is object level locking ? where do appear this type of locking ?

3504


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

992


Can you connect multiload from ab initio?

1225


Difference between stored procedure and macro?

1174


What is oltp?

983


What is partitioned primary index (ppi)?

1053