Questions tagged [reduction]
481 questions
-5
votes
1 answer
How to reduce time in MySQL while scanning the table?
I have the following query:
select count(inspection_result) from copygtron where (inspection_time between "2015-07-15" and "2015-07-21") and inspection_result= 1 and part_type = "39000048" and location = "1" union all
select…