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