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 are some commonly used bteq scripts?
What is upsert statement in teradata?
What is a sparse index?
What is the purpose of indexes?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are different table types used in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Which is faster fastload or multiload?
Explain the term 'foreign key' related to relational database management system?
What are differences between teradata and ansi session modes in teradata?
Where is teradata rdbms used?
What are the various reporting tools in the market?
Describe primary index in teradata. And what are the available primary index types?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
List the logical and conditional operators that are used with teradata along with their meanings?
