Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the various reporting tools in the market?
What are the multiload utility limitations?
What are some primary characteristics of teradata?
Why is the case expression used in teradata?
What are the string manipulation operators and functions associated with teradata?
What is a sparse index?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is the purpose of indexes?
What is meant by a Least Cost Plan?
Explain the new features of teradata?
What is meant by a node?
what is sysdba and sysdbc ? which has high priority ?
What are different table types used in teradata?
Syntax for case when statement?
What is logical data model?
