何时在已连接表上添加索引

I have a mysql table with 9 million records that doesn't have any indices set. I need to join this to another table based on a common ID. I'm going to add an index to this ID, but I also have other fields in the I have a mysql table with 9 million records tha