Composite indexes

You can create an index that includes multiple columns. For example, you might create the following index:

CREATE INDEX c_temp2 ON customer (cust_num, zipcode);