Answer / bhanu prasad

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

Answer / innocent

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

Answer / innocent

--Find indixes.
Select TableName,ColumnName,IndexType,UniqueFlag,IndexName
From DBC.Indices
Where tableName='mytable_name'

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.

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.

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  

What is the purpose of using case expression in teradata?

0 Answers  

If table have access lock.In the same table write lock is posible or not?

1 Answers  

On which column will you take primary index???

4 Answers  

what are the default access rights in the teradata?

1 Answers  

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

How to run the Teradata jobs in unix environment ???

4 Answers   IBM,

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

Explain fastload in teradata?

0 Answers  

what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,