Optimization Hints

This Wiki is read-only for reference purposes to avoid broken links.

Every installation has specific needs for optimal performance tuning.

Some database optimisation tips can help with tuning tasks:

Big non-transaction tables

create index with (AD_Org_ID, AD_Client_ID, IsActive)
create index with (UPPER(Value))
create index with (UPPER(Name))

Big transaction tables

create index with (AD_Org_ID, AD_Client_ID, DocStatus, Processed, Posted)

Big AD_ChangeLog

create index for ad_changelog with (ad_table_id, record_id)

Normal database tips

• Separate index, data and blob tablespaces