
-- creation of an index for a table
create index zipidx
on customer(zip);

-- retrieval query makes use of the index to expedite the search
select *
from customer
where zip = '33503';

-- removal of an index
drop index zipidx on customer;