We can find the information of all the indexes in the system table "

Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?

Question Posted / bhanu prasad

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

Please Help Members By Posting Answers For Below Questions

Can we collect statistics on multiple columns?

987

How does hashing happens in teradata?

1017

What is meant by a node?

991

Explain teradata utilities. What is multiload, fast load, tpump?

948

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

958

Difference between inner join and outer join?

951

Highlight all the modes that are present under Confidence Level.

916

How can bottlenecks be identified?

956

What is the purpose of using case expression in teradata?

955

What are the various indexes in teradata? How to use them? Why are they preferred?

997

What is the difference between teradata and basic rdbms?

950

What are aggregate tables? How do you design them using teradata?

1092

Explain parsing engine in teradata?

1024

What is the primary index in teradata?

1113

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361