create index battles_attacker_i on battles(attacker); create index battles_defender_i on battles(defender);