what is the difference between primary index and secondary index?.
Answer Posted / tdguy
PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you mean by tpt in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How many sessions of MAX is PE capable of handling at a particular time?
How is MLOAD Client System restarted after execution?
Name the five phases that come under MultiLoad Utility.
In BTEQ, how are the session-mode parameters being set?
Describe primary index in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
In Teradata, what is the significance of UPSERT command?
What is upsert statement in teradata?
What is the function of parser component in teradata?
What is inner join and outer join?
Highlight the points of differences between the database and user in Teradata.
Difference between stored procedure and macro?