Answer Posted / 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

What is the difference between global temporary tables and volatile temporary tables?

1164

---

What is dimensional modeling?

1078

---

What are default access rights in teradata?

1109

---

In BTEQ, how are the session-mode parameters being set?

1140

---

What is the use of stored procedures in teradata?

996

---

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

1005

---

Discuss the advantages of using partitioned primary index in a query?

945

---

What's the difference between timestamp (0) and timestamp (6)?

1179

---

What is collect statistics?

993

---

Explain the term 'database' related to relational database management system?

977

---

What are the design features involved in teradata?

1050

---

What are the various indexes in teradata?

1044

---

What does Amp contain and what are all the operations that it performs?

995

---

What do you mean by teradata intelliflex?

1086

---

What is meant by a dispatcher?

1008

---