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

How can we check the version of Teradata that we are using currently?

1067

---

List out all forms of LOCKS that are available in Teradata.

969

---

What is upsert statement in teradata?

1137

---

Which is faster fastload or multiload?

1114

---

What are the scenarios in which full table scans occurs?

1008

---

Define views in teradata with syntax.

1077

---

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

1036

---

What are the commands to make a new table, change a table and remove a table in teradata?

1132

---

What are normalization, first normal form, second normal form and third normal form?

1052

---

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

984

---

What do you mean by tpt in teradata?

1021

---

What is meant by a Clique?

1063

---

Explain and compare pros and cons of snow flake schemas?

1035

---

What is TPD?

1373

---

What are the available primary index types in teradata.

1032

---