Interested to Buy Any Domain ? << Click Here >> for more details...
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 exactly do you know about catching in teradata?
What is collect statistics?
How to find duplicates in a table?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the maximum number of dml can be coded in a multiload script?
List out some of the primary characteristics of teradata.
What is teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the purpose of upsert command?
Can you fastexport a field, which is primary key by putting equality on that key?
What is the use of having index on table?
How do you do backup and recovery in teradata?
What is bteq script in teradata?
Highlight all the modes that are present under Confidence Level.
