Mysql查詢最佳化隨筆記錄

標籤：

select SQL_CALC_FOUND_ROWS * from (select * from  oses_vehdata201606 union all  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 

結果：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 

結果：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 

結果：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 

結果：0.176s、0.052

資料庫最佳化部落格http://www.ihref.com/read-16422.html

MySQL索引和查詢最佳化

 

Mysql查詢最佳化隨筆記錄