How to treat a smaller table on the inner side of the join in Vertica
Environment
Vertica Analytics Database: version All
Situation
The optimizer treats a larger table on the inner side of the join. This results in drastic performance degradation. How to force the optimizer treat a large table on the inner side.