I have a MySQL (yes, I know) database with two relevant tables, t with 52230 rows and r with 5 rows. r has primary key r_id and t has foreign key r_id -> r.r_id. I have indices on (t.r_id), (t.date), ...