Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sailendra
Actually we have two types of primary index in teradata
1.Unique Primary Index and
2.Non unique primary index
unique primary index are generated on the unique columns
and by default it will take the first column if you have
not specified it as unique primary index.
In non unique primary index we can have two rows with same
values.
But the main purpose of selecting a column as primary index
is the uniqueness of the column and the frquency of the
column used in the queries and in the join conditions.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we collect statistics on table level?
What are the components used in smp and massively parallel processing (mpp) machines?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Syntax for case when statement?
What are differences between teradata and ansi session modes in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is teradata? What are some primary characteristics of teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What do you mean by ttu in teradata?
What is the difference between fastload and multiload? Which one is faster?
What are the primary characteristics of the Teradata.
What is meant by a Clique?
What are the different methods ot loading a dimension table? A fact table etc?
What are default access rights in teradata?
Explain and compare pros and cons of snow flake schemas?
