CREATE INDEX (empcnt)ON gt_deptsal;
CREATE INDEX NamePhone (CustName, Phone)
ORDER BY HASH (CustName)
ON Customer;
CREATE INDEX ZipIdx (CustName, ZipCode)
ORDER BY VALUES (ZipCode)
ON Customer;
CREATE JOIN INDEX CustOrdIdx,
FALLBACK AS
SELECT c.CustId, c.Name, o.OrderDate, o.Status, o.Special
FROM Customer c LEFT JOIN Orders o
ON o.CustId = c.CustId
PRIMARY INDEX (CustId);