Why is my latest-report join so much slower than a manual query?
MySQL table T holds report rows for fewer than 10 companies. A view finds the latest date for each company, and another joins those company and date pairs…
MySQL table T holds report rows for fewer than 10 companies. A view finds the latest date for each company, and another joins those company and date pairs…