Interested to Buy Any Domain ? << Click Here >> for more details...
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
- 10 Answers
- 17774 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
There can be more than one primary key in TD. But PI should
always be one and can contain upto 16 columns. Performance
of Teradata is directly linked to PI. Row hash value (32
bit) is calculated from PI using the hashing function. This
hash value along with the uniqueness id (32 bit value)
helps in locating the amp.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the use of having index on table?
Explain PDE.
List the logical and conditional operators that are used with teradata along with their meanings?
Why do you get spool space errors? How do trouble-shoot them?
What is the purpose of indexes?
Is multi insert ansi standard?
Highlight the limitations of TPUMP Utility.
What are the commands to make a new table, change a table and remove a table in teradata?
Explain BYNET.
What is meant by a Virtual Disk?
What are the scenarios in which full table scans occurs?
What is the difference between union and union all in teradata?
What are the updated features of teradata?
What is the difference between fastload and multiload?
What are the steps involved in the process flow of the sql statement through channel attached system?
