create index zip_ix on customer (zipcode);