Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answers were Sorted based on User's Feedback
Answer / 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 |
Hi Parsad,
I hope by running below query you'll get many part of your
answer.
_----------------------------------------------------------_
Select DatabaseName, TableName ,columnName,
Case When IndexType='K' Then 'Primary Key'
When IndexType='S' Then 'Secondary Index'
When IndexType='P' Then 'Primary Index'
When IndexType='Q' Then 'PPIndex'
When IndexType='J' Then 'Join Index'
End as implimented_Index
From DBC.Indices
Where TableName in
( Select distinct TableName
From DBC.Tablesize
Where DatabaseName <>'DBC'
And
CurrentPerm>0
)
Order by 1,2,3
_
Innocent
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / 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 |
What is the default join strategy in Teradata???
What are the things to be considered while creating secondary index?
What is bteq utility in teradata?
How does hashing happens in teradata?
What are the different design perspectives used in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
If RDBMS is halted what will you do ?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
How do you load Multiple files to a table by using fastload scripts?
What is the function of parser component in teradata?
What is database exceptions in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?