How to find the no:of amps involved in storing the data of a table?

Database
Enthusiast

How to find the no:of amps involved in storing the data of a table?

Hi All,

I want to know the no:of amps/Amp number details involved in storing the data of table. Is there any Way?

EG: my table is having 1000 rows of data.
My TD database capacity is 600 TB. having some 150000 tables under 7000 databasenames,2500 amps, 80 nodes etc.

I want to know if we have any query to find these details? or any logical way to identify the amp details ?

Please share the info.......

Thanks in Advance !

Chakri
3 REPLIES

Re: How to find the no:of amps involved in storing the data of a table?

Perform select * from table_name and EXPLAIN the sql statement.
Hope it will help you
Enthusiast

Re: How to find the no:of amps involved in storing the data of a table?

I got the answer myself.......

select hashamp(hashbucket(hashrow(PI columns))) from databasename.tablename;

result :you can see the details of amp on which the data is stored....
Enthusiast

Re: How to find the no:of amps involved in storing the data of a table?

Another way to find number of AMPs.

select count(*) from dbc.tablesize where tablename =