On multi table join optimization

At present, the performance of a single table is very good. However, the performance of two or more large table joins is not very good. I would like to know whether there has been any optimization for this area recently. Currently, other products have done better in this area, such as Apache Doris and ByteHouse