After completing the redistribution of data across a nodegroup, it is strongly recommended that you do a RUNSTATS to update the statistics associated with the tables that may have been redistributed.
For more information on the RUNSTATS command, refer to the Command Reference manual.