|
|
|
Junior Member
 
Group: Forum Members
Last Login: 7/29/2006 11:12:00 PM
Posts: 12,
Visits: 1
|
|
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?
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
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
|
|
|
|