Answer Posted / 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 |
Post New Answer View All Answers
What are types of partition primary index (ppi) in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are default access rights in teradata?
List out all forms of LOCKS that are available in Teradata.
How many tables can you join in v2r5?
What are differences between teradata and ansi session modes in teradata?
What do you mean by ttu in teradata?
Explain the advantages of partitioned primary index in a query?
What is meant by a Virtual Disk?
Describe primary index in teradata. And what are the available primary index types?
Explain the teradata primary index mechanics in detail with a diagram.
What is primary index and secondary index?
Explain the term 'primary key' related to relational database management system?
How would you load a very large file in teradata in general?
What is the difference between global temporary tables and volatile temporary tables?