Business unit transfer activity completion might take a long time

You might encounter slow performance during transfer of business unit activity. To improve performance, you can implement the following solutions.

  • Add the following indexes:
    • CREATE INDEX "IDSLDAP2"."TESTIDX1" ON "IDSLDAP2"."SN" ("SN" ASC, "EID" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
    • CREATE INDEX "IDSLDAP2"."TESTIDX2" ON "IDSLDAP2"."OBJECTCLASS" ("EID" ASC, "OBJECTCLASS" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
    • CREATE INDEX "IDSLDAP2"."TESTIDX3" ON "IDSLDAP2"."LDAP_DESC" ("DEID" ASC, "AEID" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
  • Update the table statistics by using Identity Manager performance tuning scripts.
  • Perform the business unit transfer activity during the time of least activity on the application server.