Interested to Buy Any Domain ? << Click Here >> for more details...
On which column will you take primary index???
- 4 Answers
- 8857 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Generally, PI on an unique column would be recommended.
This is because, the unique primary index helps TD to
distribute the row evenly among amps.
| Is This Answer Correct ? | 29 Yes | 0 No |
Answer / 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 |
Answer / sailendra
Actually we have two types of primary index in teradata
1.Unique Primary Index and
2.Non unique primary index
unique primary index are generated on the unique columns
and by default it will take the first column if you have
not specified it as unique primary index.
In non unique primary index we can have two rows with same
values.
But the main purpose of selecting a column as primary index
is the uniqueness of the column and the frquency of the
column used in the queries and in the join conditions.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / malathi
Primay key is a constraint used on a table and used to
impose the rule of uniqueness for the application.
Whereas primary index is the way tera data internally
distributes rwos in a table. Primary index can be created
on any column which may mot be a primary key. In teradata
each table should have a primary index (be default first
column in the table is primary indexed).
| Is This Answer Correct ? | 3 Yes | 6 No |
What is the difference between teradata and basic rdbms?
What is teradata and why it is used?
what is identity columns in TD?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
What are default access rights in teradata?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
what is the difference between primary index and secondary index?.
What is FILLER command in Teradata?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What do you mean by parsing?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Teradata 
