创建索引

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);