How hot/warm architecture enhances query performance?

It all depends on what is limiting your performance with the current architecture. Less data on the node means more data can be cached, but to what extent this benefits you will depend on your query patterns. I can therefore not tell you to what extent this will improve performance. This is why I recommend you benchmark it with as realistic load as possible to find out for sure.