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
What are the available join types in teradata?
What are the various indexes in teradata? How to use them?
What are the various indexes in teradata?
What are some commonly used bteq scripts?
Define views in teradata with general syntax.
What is collect statistics?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is meant by a Least Cost Plan?
What can be achieved by using the teradata rdbms?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Difference between inner join and outer join?
Is multi insert ansi standard?
Explain and compare pros and cons of snow flake schemas?
What do you mean by tpt in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
