Thank you again.
Subquery approach has been recommended to our team as a long term solution.
However, for short-tem solution to avoid regression impact, using view with limited partitions has been selected.
If I remember correctly, in MySQL `table A` data can be limited by `ON Clause` before joining so that cadidates for join can be reduced.
Thank you for your valuable comment.