mysql - 详细论述联表查询与分步查询的优缺点

Answer 1

In fact, the biggest advantage of step-by-step query is that it facilitates horizontal segmentation. Therefore, many companies have begun to gradually remove JOIN and subqueries.

In addition, JOIN has two major disadvantages:

1. It is not easy to identify the execution plan;

2. NULL is easily generated in query results.