Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / bhanu prasad
We can find the information of all the indexes in the
system table "dbc.indices"
Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What are the 5 phases in a multiload utility?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is meant by a Parsing Engine?
What are the different table types that are supported by teradata?
What are the various indexes in teradata? Why are they preferred?
Explain the parallel data extension in teradata?
Difference between star and snowflake schemas?
List out all forms of LOCKS that are available in Teradata.
What is the use of fallback?
What are the functions performed by bynet?
Explain the teradata primary index mechanics in detail with a diagram.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What does Amp contain and what are all the operations that it performs?
Why do you get spool space errors? How do trouble-shoot them?
What are the different functions performed in development phase?