Redshift historical retrieval query performance regression

There seems to have been some regression in historical retrieval for Redshift that happened somewhere between 0.14.1 and 0.16.1. A quick summary of one particular user's issue:

- currently the point-in-time joins on big entity dataframes are slow in Redshift. The entity_df is generated right now by creating e.g. a `user_id` CROSS JOIN `item_id`
- The tables in question have usually have 2-4 columns per feature view, and models use between 10 - 30 feature views.

@woop had done some quick investigation and the main shift seemed to happen in https://github.com/feast-dev/feast/pull/1911 introduced by @MattDelac