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
How would you load a very large file in teradata in general? What utility would you use for it? Why?
During the Display time, how is the sequence generated by Teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Explain teradata architecture?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the commands to make a new table, change a table and remove a table in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What are aggregate tables? How do you design them using teradata?
Explain and compare pros and cons of start schemas?
What is the use of fallback?
What is TPD?
What are the available join types in teradata?
Which is faster fastload or multiload?
What are the primary characteristics of the Teradata.
