I'm have a part table like this:
part_id INT manufacturer_id INT supplier_id INT part_number VARCHAR(50) part_description VARCHAR(120)
with foreign keys:
CONSTRAINT fk_supplier_to_part FOREIGN KEY supplier_id REFERENCES supplier.supplier_id CONSTRAINT fk_manufacturer_to_part FOREIGN KEY manufacturer_id REFERENCES manufacturer.manufacturer_id
KEY ix_supplier_id (part.supplier_id) KEY ix_manufacturer_id (part.manufacturer_id) KEY fk_supplier_to_part (part.supplier_id) KEY fk_manufacturer_to_part (part.manufacturer_id)
My question is, are the ix_supplier_id and ix_manufacturer_id indexes required? I know that a foreign key needs a 'matching index' but does the index need to have the same name as well as matching columns?