Oracle Warehouse Builder (OWB) Weblog

Always good to speed up things in a product. I just applied a few indexes on my repository and it really seems faster in retrieving the details of my jobs. The issue is officially fixed in the 10.2.0.2 patch, but I figured I try this on my own 10.2.0.1 repository and it seems to nicely work...

First of all, make sure you use the Tools --> optimize Repository to refresh statistics (and do this once in a while!).

Now apply the following indexes in the repository:

CREATE INDEX "WC_RT_IDX_AO_OU" ON "WB_RT_AUDIT_OBJECTS" ("OBJECT_UOID");

CREATE INDEX "WC_RT_IDX_AO_PA" ON "WB_RT_AUDIT_OBJECTS"
("PARENT_AUDIT_OBJECT_ID");

Works for me...