MySQL query optimization essay record

Select Sql_calc_found_rows * FROM (SELECT * To oses_vehdata201606 UNION ALL SELECT * from oses_vehdata201605) T wher e 1=1 and t.check_time between ' 2016-06-23 00:00:00 ' and ' 2016-06-23 23:59:59 ' ORDER BY check_time Desc

Results: 45.66 S, 36.5s

Select Sql_calc_found_rows * FROM (SELECT * from oses_vehdata201606) t where 1=1 and t.check_time between ' 2016-06-23 00 : 00:00 ' and ' 2016-06-23 23:59:59 ' ORDER BY check_time Desc

Results: 8s, 9s

Select Sql_calc_found_rows * FROM (SELECT * from oses_vehdata201605) t where 1=1 and t.check_time between ' 2016-06-23 00 : 00:00 ' and ' 2016-06-23 23:59:59 ' ORDER BY check_time Desc

Results: 7s

Select Sql_calc_found_rows * from oses_vehdata201606 t where 1=1 and t.check_time between ' 2016-06-23 00:00:00 ' and ' 2016 -06-23 23:59:59 ' ORDER BY check_time Desc

Results: 0.176s, 0.052

Database Optimization Blog http://www.ihref.com/read-16422.html

MySQL indexing and query optimization

MySQL query optimization essay record