Pair foreign key references with indexes where necessary.