Because the way we are querying this table is to get all rows by disease group ID, it is better to swap around the columns i.e. (disease_group_id, global_gaul_code) so that the index gets used.