Example of a Basic MySQL Index Statement

CREATE INDEX ShipsbyshipClass_ix ON Ships (shipClass);

CREATE INDEX space_firsts_ship_Sponsor_ix

ON space_firsts (eventShip, eventSponsor);

This lower example is indexing on 2 fields