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 does sleep function does in fast load?
What are the advantages of teradata?
What is the difference between global temporary tables and volatile temporary tables?
Which is more efficient group by or distinct to find duplicates?
Explain the term 'columns' related to relational database management system?
Explain the term 'foreign key' related to relational database management system?
What is a dimension table?
What are the functions performed by bynet?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the different table types supported by teradata?
What are the different functions included in the server software?
Explain BYNET.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain fallback in teradata?
how do you manage the production space. what are the proactive methods you can take ?
