Interested to Buy Any Domain ? << Click Here >> for more details...
Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
- 5 Answers
- 26978 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
Hi Innocent,
Appreciate for your answer.
But one small correction is that tablename and database name columns are present in DBC.indices itself where as you had went for a join condition with dbc.tablesize.
so without join condition we can take both tablename and database from dbc.indices table.
Thanks
Prasanna.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the available join types in teradata?
Explain fastload in teradata?
What is node? How many nodes and amps used in your previous project?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the various indexes in teradata?
How many codd's rules are satisfied by teradata database?
What is the difference between union and union all in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are some commonly used bteq scripts?
Which is more efficient group by or distinct to find duplicates?
What are the uses of client software involved in teradata?
List out all forms of LOCKS that are available in Teradata.
Explain PDE.
