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

On which column will you take primary index???

Answer Posted / saidulu

In PI(Primary Index) also we have 2 types ie (unique
PI ,Non unique PI)
how can we say unique column as primarIndex.If it is
non unique PI means it allows duplicates.

Now i am comming to which column as Primary Index
1.Frequntly using column.
2.Not regularly changing column
(Not at all changing values /rarely)
3.By default it takes as first column as PI

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a node in teradata? Explain

942


What are the different functions included in the server software?

979


Can you connect multiload from ab initio?

1138


Explain the most common data types used in teradata?

989


What are normalization, first normal form, second normal form and third normal form?

997


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

1036


What are the string manipulation operators and functions associated with teradata?

1028


What is the syntax for case when statement?

1059


How to view every column and the columns contained in indexes in teradata?

983


What are the various indexes in teradata? How to use them? Why are they preferred?

1002


What are different table types used in teradata?

981


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1726


Explain the meaning of Amp?

1036


How to identify ppi columns?

1103


why use references rather than pointers in the public api, particularly for arguments which are modified?

940