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”;