Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
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?
List out teradata data types?
During the Display time, how is the sequence generated by Teradata?
Highlight the limitations of TPUMP Utility.
Explain and compare pros and cons of snow flake schemas?
What is meant by a Virtual Disk?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is basic teradata query language?
What is the difference between fastload and multiload?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain parsing engine in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Syntax for case when statement?
Explain fallback in teradata?
Discuss the advantages of using partitioned primary index in a query?