Adding to the above,DBC.Indexes can be used to find whether the index is

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

Question Posted / yuvaevergreen

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

Please Help Members By Posting Answers For Below Questions

How to identify ppi columns?

1244

Steps to create a data model?

1180

What is a three-tier data warehouse?

1151

What are the scenarios in which full table scans occurs?

1052

What are the main components of teradata system?

1192

What are the uses of bynets in multi-node systems?

1071

What is called partitioned primary index (ppi)?

1054

What are the enhanced features in teradata v2r5 and v2r6?

1184

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242

any one answer me how they can analyzing the project using data ware housing?

2520

How do you set the session mode parameters in bteq?

1138

Describe the between keyword in teradata?

1081

How to load specific no.of records using bteq, or fastload,or multiload

1814

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1210

What interface is used to connect to windows based applications?

1167