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 is the use of fallback?
Explain the advantages of partitioned primary index in a query?
Highlight the differences between Primary Key and Primary Index.
What is the use of teradata system software?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the purpose of using case expression in teradata?
What is meant by a Channel Driver?
Did you write stored procedures in teradata?
How does hashing happens in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What do you mean by teradata intelliflex?
List out all forms of LOCKS that are available in Teradata.
Where is teradata rdbms used?
What is meant by a Parsing Engine?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
