HP 3000 Manuals

ALLBASE/SQL Reference Manual

CREAINDEX Command File 

     /* This file creates the indexes for the PurchDB database  */
     /* and then updates the statistics for each of the tables.    */

     CREATE UNIQUE INDEX PartNumIndex
          ON PurchDB.Parts (PartNumber);
     CREATE CLUSTERING INDEX PartToNumIndex
          ON PurchDB.SupplyPrice (PartNumber);
     CREATE INDEX PartToVendIndex
          ON PurchDB.SupplyPrice (VendorNumber);
     CREATE UNIQUE INDEX VendPartIndex
          ON PurchDB.SupplyPrice (VendPartNumber);
     CREATE UNIQUE INDEX VendorNumIndex
          ON PurchDB.Vendors (VendorNumber);
     CREATE UNIQUE CLUSTERING INDEX OrderNumIndex
          ON PurchDB.Orders (OrderNumber);
     CREATE INDEX OrderVendIndex
          ON PurchDB.Orders (VendorNumber);
     CREATE CLUSTERING INDEX OrderItemIndex
          ON PurchDB.OrderItems (OrderNumber);
     CREATE UNIQUE INDEX InvPartNumIndex
          ON PurchDB.Inventory (PartNumber);

     :echo Indexes have been created on tables in PurchDB!;

     UPDATE STATISTICS FOR TABLE ManufDB.SupplyBatches;
     UPDATE STATISTICS FOR TABLE ManufDB.TestData;
     UPDATE STATISTICS FOR TABLE PurchDB.Parts;
     UPDATE STATISTICS FOR TABLE PurchDB.Inventory;
     UPDATE STATISTICS FOR TABLE PurchDB.SupplyPrice;
     UPDATE STATISTICS FOR TABLE PurchDB.Vendors;
     UPDATE STATISTICS FOR TABLE PurchDB.Orders;
     UPDATE STATISTICS FOR TABLE PurchDB.OrderItems;
     UPDATE STATISTICS FOR TABLE PurchDB.Reports;
     UPDATE STATISTICS FOR TABLE RecDB.Members;
     UPDATE STATISTICS FOR TABLE RecDB.Clubs;
     UPDATE STATISTICS FOR TABLE RecDB.Events;

     :echo Statistics have now been updated for all tables!;

MPE/iX 5.5 Documentation