Adding more lookup decreasing the performance (Redshift lookup / SQL server Lookup)

Well, query lookup, especially on databases, can be very high. Is there an option to cache it? Some ETL products run a query to get all candidates, and they use a binary tree to search it. It is not only a bit faster because it gets rid of so much network traffic and latency, but it also is faster because you have ONE moderate operation instead of maybe thousands or more ones that are smaller but still very expensive.

The join, works essentially the same way the binary tree method would, but requires changing your logic a little, etc…

Steve