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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by tpt in teradata?

959


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

978


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3536


How many sessions of MAX is PE capable of handling at a particular time?

1030


How is MLOAD Client System restarted after execution?

1055


Name the five phases that come under MultiLoad Utility.

928


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

1086


Describe primary index in teradata?

956


In the Primary Index, what is the score of AMPs that are actively involved?

997


In Teradata, what is the significance of UPSERT command?

1127


What is upsert statement in teradata?

1051


What is the function of parser component in teradata?

1035


What is inner join and outer join?

1037


Highlight the points of differences between the database and user in Teradata.

1037


Difference between stored procedure and macro?

1108