Unionall is inefficient. which method should be used to solve the problem of stored procedures, views, and temporary tables? Union & nbsp; all is inefficient. The union & nbsp; all has dozens of tables. The select statement for a single table takes only 0.0003-0.002 seconds, but union & nbsp; it takes about 0.6 seconds after all to improve efficiency. in this case, which of the following solutions should I use stored procedures, views, and temporary tables? Union all is inefficient. Which of the following solutions should we use stored procedures, views, and temporary tables?
Union all is inefficient. It takes about 0.0003-0.002 seconds to select a single table with dozens of union all tables, but it takes about 0.6 seconds after union all.
To improve efficiency
In this case, which of the following methods should be used to solve the problem?
------ Solution --------------------
How big is the data volume? When the number of sub-tables is reached. This horizontal score is not reasonable for table sharding.
------ Solution --------------------
After union all, order and so on? Shouldn't it be so big?
