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

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

1026

Highlight the need for Performance Tuning.

1103

What do you mean by parsing?

1108

What are the different functions performed in development phase?

1073

Define views in teradata with general syntax.

1021

Explain the teradata primary index mechanics in detail with a diagram.

969

Highlight the limitations of TPUMP Utility.

1111

Which is faster fastload or multiload?

1103

What is a node in teradata?

990

Explain and compare pros and cons of snow flake schemas?

1030

Difference between star and snowflake schemas?

1141

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1945

What do high confidence, low confidence and no confidence mean in explain plan?

1043

What is the opening step in basic teradata query script?

1034

why use references rather than pointers in the public api, particularly for arguments which are modified?

999