Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / yuvaevergreen
Adding to the above,DBC.Indexes can be used to find whether
the index is PPI or join or hash or primary key.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the use of virtual processor connectivity in teradata?
if collect stats but it show low confidence why?
In the Primary Index, what is the score of AMPs that are actively involved?
What is meant by a Clique?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What tools would you use for that?
What is the difference between teradata and basic rdbms?
What are the different softwares used with their functions in teradata?
What do you mean by parsing?
Highlight a few of the important components of Teradata?
Why managing the data is important?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Describe the set operators in teradata.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the various indexes in teradata? How to use them?