The following command file creates an index on the zipcode column of the customer table:
CREATE INDEX zip_ix ON customer (zipcode);