Mysql database join Optimization

Table 1goodscategory_idgoodscategory_name table 2goods_idgoods_cidgoods_name is associated with goods_cid and goodscategory_id through the join statement. Is there any other method to join the table using this method? Join feels slow table 1

Goodscategory_id
Goodscategory_name

Table 2
Goods_id
Goods_cid
Goods_name

Use the join statement goods_cid to associate with goodscategory_id.

Is there any other solution besides this method for table join? Join feels slow

Reply content:

Table 1

Goodscategory_id
Goodscategory_name

Table 2
Goods_id
Goods_cid
Goods_name

Use the join statement goods_cid to associate with goodscategory_id.

Is there any other solution besides this method for table join? Join feels slow

Retrieve data from a single index table, and performJoinOperation.JoinAndSubqueryIt's all about mysql.