Answer Posted / yuvaevergreen
Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the new features of teradata?
What is the multi-insert?
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 do high confidence, low confidence and no confidence mean in explain plan?
What do you mean by ttu in teradata?
Is multi insert ansi standard?
Steps to create a data model?
What are the uses of bynets in multi-node systems?
any one answer me how they can analyzing the project using data ware housing?
How many tables can you join in v2r5?
How many types of joins are there in teradata?
What is the difference between fastload and multiload? Which one is faster?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
if collect stats but it show low confidence why?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?