Dropping Data Distributions

When you upgrade to a new version of the database server, you might need to drop distributions to remove the old distribution structure in the sysdistrib system catalog table.

UPDATE STATISTICS DROP DISTRIBUTIONS;