Please could someone advise whether it is necessary/advisable or not
to create separate indices for each Primary or Foreign key contraint
fields?

Any links to online resources that can provide some insight into this
query would also be very appreciated.

Thanks in advance