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 are the frequently used data types in teradata?

1131

---

What is the multi-insert?

1082

---

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

1114

---

What is the purpose of indexes?

1128

---

What is the use of stored procedures in teradata?

1046

---

What are the components provided on node?

1089

---

Explain how spool space is used.

1111

---

What is the difference between fastload and multiload?

1460

---

Highlight all the modes that are present under Confidence Level.

1010

---

In Teradata, what is the significance of UPSERT command?

1314

---

Highlight the need for Performance Tuning.

1154

---

What do you mean by ttu in teradata?

1082

---

What is stored procedure in teradata?

1085

---

What do you mean by fastexport in teradata?

1044

---

What are the enhanced features in teradata v2r5 and v2r6?

1184

---