ALLBASE/SQL Reference Manual (36216-90216)

638 AppendixC

Sample DBEnvironment

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