teradata architecture

Tools & Utilities
Enthusiast

teradata architecture

1.How to get row_id information in case of teradata.Like in the case of oracle you can give sel row_id from table_name and get the row_id information.

2.Where can i get information on table_header where is it stored and how can i access it?
1 REPLY
Enthusiast

Re: teradata architecture

Hi

Try this

SELECT hashamp (hashbucket (hashrow (Primary index)))
as "AMP"
FROM tablename

hashrow gives the row hash value

hashbucket gives the bucket value that maps the AMP

hashamp gives the AMP in which the data is distributed