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
Why managing the data is important?
Define views in teradata with general syntax.
What is smp and mpp platforms?
Steps to create a data model?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is meant by a Highest Cost Plan?
What is the maximum number of dml can be coded in a multiload script?
how do you manage the production space. what are the proactive methods you can take ?
What are the different softwares used with their functions in teradata?
what is object level locking ? where do appear this type of locking ?
How many sessions of MAX is PE capable of handling at a particular time?
How many codd's rules are satisfied by teradata database?
What are the steps involved after the disk manager passes the request?
Which is more efficient group by or distinct to find duplicates?
How to view every column and the columns contained in indexes in teradata?