All Forums Tools
sunitha-2928 12 posts Joined 07/06
18 Jul 2006
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?

giri 24 posts Joined 11/05
18 Jul 2006

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

You must sign in to leave a comment.