Teradata创建索引

1

CREATE INDEX DeptIdx (DeptNo)
   ON employee;

 

 

2

CREATE INDEX NamePhone (CustName, Phone)
   ORDER BY HASH (CustName)
   ON Customer;

 

3

CREATE INDEX ZipIdx (CustName, ZipCode)
   ORDER BY VALUES (ZipCode)
   ON Customer;

 

 4

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