number of rows per AMP - BEFORE RECONFIGURATION

Database
Enthusiast

number of rows per AMP - BEFORE RECONFIGURATION

Hi,

I know how to check data distribution per AMP using primary index columns. Easy.

However,  I have a table , couple of weeks later new AMPs are added and reconfiguration hasn't been done yet.

How can I determine how many rows are currently belonging to AMPs ?

Regards,

Piotr

Tags (1)
1 REPLY
Junior Contributor

Re: number of rows per AMP - BEFORE RECONFIGURATION

Hi Piotr,

I don't know if I understood you correctly, but if the reconfig didn't run yet, the new AMPs are unknown to the system. So you run the same query as before...