Cross joins I use to ensure there are no "holes" in my table that I am using as backbone for subsequent queries, (e.g. by aggregating information from multiple

Cross joins I use to ensure there are no "holes" in my table that I am using as backbone for subsequent queries, (e.g. by aggregating information from multiple tables based on date and country) For full outer join, well you need to create dim tables sometimes half ad-hoc and full outer seems to be much faster solution than UNION