Toad World® Forums

Health Check FK Scripts

The DB health check of foreign keys that are not index generates code for missing indexes. For a given table all the indexes to be created have the same name. See below and the attached.

CREATE INDEX BIOCARE.FACT_INVENTORY_IND1 ON BIOCARE.FACT_INVENTORY (COST_CENTER_KEY);
CREATE INDEX BIOCARE.FACT_INVENTORY_IND1 ON BIOCARE.FACT_INVENTORY (DISTRIBUTOR_KEY);
CREATE INDEX BIOCARE.FACT_INVENTORY_IND1 ON BIOCARE.FACT_INVENTORY (PRODUCT_KEY);

Thanks Ed. I'll take a look at this soon.