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