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 happens when a node suffers a downfall?

1077

---

What are the different table types supported by teradata?

914

---

Highlight the advantages of PPI(Partition Primary Index).

1039

---

What is spool space? Why do you get spool space errors?

971

---

What are the components used in smp and massively parallel processing (mpp) machines?

1018

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1123

---

Explain teradata utilities?

1003

---

how many modules are there in telecome domain?how to explain the architecture?

1980

---

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

1057

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1740

---

How do you verify a complicated sql?

1031

---

What is collect statistics?

957

---

Can you connect multiload from ab initio?

1161

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1009

---

What are the different design perspectives used in teradata?

947

---