Tuning pluggable SQL

You can tune the SQL statements generated using the administration services to suit customized requirements or improve performance.

About this task

InfoSphere® MDM is shipped with out-of-the-box pluggable SQL statements for certain inquiry levels. If you wish to tune these out-of-the-box SQL statements, you must create a user-defined version of the inquiry level, along with all associated objects, and then tune the SQL generated from this new version of the inquiry level.

Procedure

  1. Modify the SQL statement as required.
    SQL statements for inquiry levels are concatenated using the delimiter <STMT>. You must maintain the same pattern while tuning the SQL.
  2. Use the updateInquiryLevelQuery transaction to persist the updated SQL statement.

Results

The modified inquiry level can now be used in inquiry transactions that support configurable inquiry levels.