Verify distribution

When the system creates records, it assigns them to a logical data slice based on their distribution key value. You can use the datasliceid keyword in queries to determine how many records are stored on each data slice and thus, whether the data is distributed evenly across all data slices.

To check your distribution, run the following query:

select datasliceid, count(datasliceid) as “Rows”
from table_name group by datasliceid order by “Rows”;

You can also view the distribution from the NzAdmin tool. To view record distribution for a table, you must have the following object privileges:

List on the database
List on the table
Select on the table