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

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2507

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3462

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

1868

What is node? How many nodes and amps used in your previous project?

1187

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2278

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2564