如何优化两个MySQL表之间的连接？

I have two tables: p_group.full_data, which is a large dataset I'm working on (100k rows, 200 columns) and p_group.full_data_aggregated, which I've produced to summarise a load of other tables. I have two tables: p_group.full_data, which is