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

Explain BYNET.

948

---

How does hashing happens in teradata?

1019

---

How many types of joins are there in teradata?

915

---

how do you manage the production space. what are the proactive methods you can take ?

1884

---

What are aggregate tables? How do you design them using teradata?

1095

---

What tools would you use for that?

1029

---

What are the different table types that are supported by teradata?

954

---

What are the frequently used data types in teradata?

1006

---

What are the steps involved in the process flow of the sql statement through channel attached system?

1053

---

How can you track login parameters of users in teradata?

1126

---

What are the uses of bynets in multi-node systems?

968

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017

---

What is TPD?

1308

---

How do you set the session mode parameters in bteq?

1035

---

Where is teradata rdbms used?

1038

---