You should always collect statistics on the primary index or primary AMP index of small tables that you plan to join regularly to large tables to ensure maximal star join optimization.
You should always collect statistics on the primary index or primary AMP index of small tables that you plan to join regularly to large tables to ensure maximal star join optimization.